cancel
Showing results for 
Search instead for 
Did you mean: 

DROP TABLE

former_member533538
Participant
0 Kudos

Hello,i connect to oracle DB as sysdba,run command:select owner from dba_tables where table_name='SAPUSER';

the output is like this:

OWNER

OPS$SLM02\SLMADM

but when i run below command,it prompt that table or view does not exist

drop table OPS$SLM02.SAPUSER;

or

drop table OPS$SLMADM.SAPUSER;

or

drop table OPS$SLM02\SLMADM.SAPUSER;

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If there are special characters in the name of the table or the schema, you have to use double quotes:

drop table "OPS$SLM02\SLMADM".SAPUSER;

former_member533538
Participant
0 Kudos

yes,that's right.

Answers (1)

Answers (1)

nirmal_konchada
Active Contributor
0 Kudos

Use "drop table <SchemaOwner>.<TableName>

Regards,

Nirmal.K