Delete contents of the tables

[Former Member]

Hello colleagues!

I have some troubles with deleting table contents. I've made the 1st step from note 1081770, but I can't make step 2: Delete the contents of the tables D342L, D345T and D346T. How can I do it? I've tried to make it via sqlplus:

SQL> desc SAPSR3.D342L

Name Null? Type

-

---

-

---

-

---

PROGNAME NOT NULL VARCHAR2(120)

STATUS NOT NULL VARCHAR2(60)

TYPE NOT NULL VARCHAR2(3)

BLOCKNR NOT NULL NUMBER(10)

BLOBLG NOT NULL NUMBER(10)

UDAT NOT NULL VARCHAR2(24)

UTIME NOT NULL VARCHAR2(18)

BLOCKLG NOT NULL NUMBER(10)

BLOCK BLOB

SQL> delete * from SAPSR3.D342L;

delete * from SAPSR3.D342L

*

ERROR at line 1:

ORA-00903: invalid table name

I can't make select request, because table has BLOB column type.

Please help me.

Artem Ivashkin

[stefan_koehler · Accepted solution]

Hello Artem,

shell> sqlplus / as sysdba
SQL> truncate table SAPSR3.D342L;
SQL> truncate table SAPSR3.D345T;
SQL> truncate table SAPSR3.D346T;

Oracle Documentation "TRUNCATE":

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10006.htm#i2067571

Regards

Stefan

[Former Member · Accepted solution]

Thank you Stefan!