I'm using Oracle 8.1.7 on a Window 2000 computer. Can you advise me?
CREATE TABLE SYSTEM.ASSETTABLESPACES_BKUP AS SELECT * FROM SYSTEM.ASSETTABLESPACES; DROP TABLE SYSTEM.ASSETTABLESPACES;
The first command creates a backup of the table, just in case. The second command drops the table, just as the error message indicates. After you have dropped the table, try your application again.
Dig Deeper on Oracle database design and architecture
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.