Oracle 11gR2 exp does not export some tables
- by Tilo Prütz
I have an Oracle 11g (11.2.0.1) Database running on Linux (x64). Within the database I have a schema and 33 tables for it. When I log in via sqlplus I can list all the tables via
SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE';
But when I export the Tablespace using
exp ... BUFFER=65536 FULL=N COMPRESS=N CONSISTENT=Y TABLESPACES=... FILE=...
Then it only exports 24 of the 33 tables.
I have tried to export the missing tables via
exp ... TABLES=<missing_table> ...
But then I get an error:
EXP-00011: NPSMIGRO2_CM.DEFAULT_USR_ATTR_VALUES does not exist
How can I find out what's wrong here?
How can I export all the tables?