I'm having problems creating an instance of Oracle 10.2.0.4 and importing a dump from other environment. I'm using Oracle under AIX.
I used a ksh script and everything goes right except when creating the users.
After that I create the default user, used to connect to the database and other working modules. The problem comes when trying to import the dump.
export ORACLE_SID=HISTO; sqlplus / as sysdba CREATE USER ANC IDENTIFIED BY "xxxxxxx"; grant connect, create session, imp_full_database to ANC; commit;
The error when trying to import de dump is the following.
Command used to load the dump:
nohup impdp ANC/xxxxxx DIRECTORY=MIG11G DUMPFILE=dump_histo.expdp LOGFILE=impdp_29102013.log schemas=HISTO &
Output from the nohup.out file:
Import: Release 10.2.0.4.0 - 64bit Production on Lundi, 23 Décembre, 2013 18:51:22 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Data Mining and Real Application Testing options ORA-31626: job does not exist ORA-31633: unable to create master table "ANC.SYS_IMPORT_SCHEMA_05" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 871 ORA-01950: no privileges on tablespace 'TOOLS'
My question: Is it normal haven't got system user to load a dump file ?
Why the load of the dump file fails ?