cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DROP TABLE

former_member533538
Participant
0 Likes
1,047

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;

View Entire Topic
nirmal_konchada
Active Contributor
0 Likes

Use "drop table <SchemaOwner>.<TableName>

Regards,

Nirmal.K