Hi there folks,
Please is it possible to migrate a DB version 10g non ASM to version 12c ASM using IMPDP or is it other "better" way to do it ??
I have created the same tablespaces at the new db, have given system user all necessary permissions (good to say that database vault is enabled) and I'm getting a tons of errors as shown below:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@spaziodbpdb directory=IMPDP dumpfile=full_spaziodb_020317.dmp logfile=spaziodbpdb1.log
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-39083: Object type TABLESPACE:"T_SCI" failed to create with error:
ORA-01119: error in creating database file '/data/oradata/spaziodb/t_sci'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Failing sql is:
CREATE TABLESPACE "T_SCI" DATAFILE '/data/oradata/spaziodb/t_sci' SIZE 104857600 AUTOEXTEND ON NEXT 52428800 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGE
MENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEG
ORA-39083: Object type TABLESPACE:"P_SCI" failed to create with error:
ORA-01119: error in creating database file '/data/oradata/spaziodb/p_sci'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Failing sql is:
CREATE TABLESPACE "P_SCI" DATAFILE '/data/oradata/spaziodb/p_sci' SIZE 104857600 AUTOEXTEND ON NEXT 52428800 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGE
MENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEG
ORA-39083: Object type TABLESPACE:"A_SCI" failed to create with error:
ORA-01119: error in creating database file '/data/oradata/spaziodb/a_sci'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Failing sql is:
I'll appreciate your concerns.
Many tks in advance,
Francisco