A few days ago while I tried perform database copy, using the database copy feature in SQL Developer, from a remote server to a local server. I got some warnings and one of them was like this:
"Error occurred executing DDL for TABLE:MASTER_DATA".
And then I clicked yes, but the result of database copy was unexpected, there were only few tables has been copied.
When I tried to see DDL from SQL section/tab on one of table, I got this kind of information:
— Unable to render TABLE DDL for object COMPANY_DB_PROD.MASTER_DATA with DBMS_METADATA attempting internal generator.
I also got this message and I believe this message showed up because there's something wrong with DDL on my database so tables won't be created.
ORA-00942: table or view does not exist
I've never encountered this problem before and I always perform database copy every day since two years ago.
For the record before this problem occurred, I have removed old .arch files manually not by RMAN and I never using any RMAN commands. I also have removed old .xml log files, because these two type of files have made my remote server storage full.
How to trace and fix this kind of problem? Is there any corruption on my Oracle?
Best Answer
The problem was caused by datafile has reached its max size though. I have resolved the problem by following the answer of this discussion https://stackoverflow.com/questions/25350703/ora-01652-unable-to-extend-temp-segment-by-128-in-tablespace-system-how-to-ext
Thank you everyone for the help.