on 01-25-2011 10:14 AM
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;
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use "drop table <SchemaOwner>.<TableName>
Regards,
Nirmal.K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.