C:\>EXPDP ****/**** DIRECTORY=DATA_PUMP_DIR DUMPFILE=PRODDTA_SCHEMA.DMP LOGFILE=PRODDTA_SCHEMA_EXP.LOG
Export: Release 10.2.0.4.0 - Production on Monday, 20 June, 2011 13:27:56
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.4.0 - Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "PRODDTA.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 871
ORA-00959: tablespace 'PRODDTATB' does not exist
Hi Guys,
I'm trying to export this particular schema but apparently it errors out on this particular tablespace PRODDTATB. This was used to reorganize the tablespace for temp storage and hence was not used and subsequently dropped. How do i find which table or view or other objects still referencing to this particular tablespace?
I've already checked the following:
dba_tables
dba_indexes
dba_segments
dba_lobs
dba_tablespaces
user_tables
user_indexes
user_segments
user_lobs
user_tablespaces
Or will creating this particular tablespace allow me to export successfully? But before i will recreate i want to find what objects still referencing this particular table space...Hope anybody can point me in the right direction.
Thanks a lot.
Edited by: user6338270 on Jun 20, 2011 12:13 AM
Added things i have looked...