Ah, I disagree. DROP TABLE will only modify the data dictionary. For example:Originally posted by jrpm
You can't.
Make the tablespace read write first, then drop the table. You can set it to read only again.
If you are in read only media, such as CD, then SOL.
Code:SQL> connect a/a Connected. SQL> create table xyz (x number(10), y date, z varchar2(20)) 2 tablespace users; Table created. SQL> connect system Enter password: ****** Connected. SQL> alter tablespace users read only; Tablespace altered. SQL> connect a/a Connected. SQL> drop table xyz; Table dropped. SQL> connect system Enter password: ****** Connected. SQL> alter tablespace users read write; Tablespace altered. SQL> desc a.xyz ERROR: ORA-04043: object a.xyz does not exist




Reply With Quote