I am new in oracle. I am trying to import an Oracle database from one machine to another by using a dump file. I'm using the below command for the import
impdp MOBILETEST/MOBILETEST directory=MOBILETEST dumpfile=MOBILETEST.dmp logfile=MOBILETEST.log full=y;
I get the error: "tablespace 'XXX_SML_INDEX' does not exist"
ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-00959: tablespace 'XXX_SML_INDEX' does not exist Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "MOBILETEST" QUOTA UNLIMITED ON "XXX_SML_INDEX"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES
WHERE TABLESPACE_NAME = ''XXX_SML_INDEX'' AND CONTENTS = ''TEMPORARY'''; EXE ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
select * from DBA_TABLESPACES
will give you a list