ORA-00959: tablespace 'XXXXXXX' does not exist
RamanJan 27 2009 — edited Jan 27 2009Hi,
I am doing export/import of schema level from prod to test environment. i have 119 tables in the prod and in test i can see only 108 tables.
once i re-started the import with missing tables=x,y,z... i am getting the following errors:
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'XXXXXXX' does not exist
IMP-00017: following statement failed with ORACLE error 959:
now still these 11 TABLES have not imported from the dump file. i dont have the same tablespace in my TEST and i dont intend to create one either....how to get the data from dmp file to this TEST.
I have no privelege to create dblinks as of now.
--Raman.