Skip to Content
avatar image
Former Member

Delete contents of the tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 21, 2009 at 09:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded