Upfront: I admit that this post is related to a previous one but that post seems to be dead so I am trying again with more information and after some of my own efforts -- so please forgive me if this is not proper but I really need answers. Thank-you.
I am trying to import an old database stucture from an old DB to an new one using expdp and impdp.
The beginning of the import log file is as follows (I have to type all this in so please excuse any typos):
----------
;;;
Import: Release 19.0.0.0.0 - Production on <import_date> Version 19.3.0.0.0
<Copyright notice>
;;;
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 = Production
;;;*******************************
;;; Parfile values:
;;; parfile: table_exists_action=replace
;;; parfile: logfile=<logfile_name>
;;; parfile: dumpfile=<dumpfile_name>
;;; parfile: directory=<directory_object_name>
;;;***************************
Master table "SYS"."SYS_IMPORT_FUL_01" successfully loaded/unloaded
<Character set possible loss of data warning>
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39083: Object type TABLESPACE:"SYSAUX" failed to create with error:
ORA_02236: invalid file name
Failing sql is:
CREATE TABLESPACE "SYSAUX" DATAFILE SIZE 849346560 AUTOEXTEND ON NEXT 849346560 MAXSIZE 32727m LOGGING ONLINE PERMANENT BLOCKSIZE 8129 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SECMENT SPACE MANAGEMENT AUTO
ORA-39083: Object type TABLESPACE:"UNDOTBS1" failed to create with error:
ORA-02236: invalid file name
------------------
This is just the first tablespace fail, there are many, many failures (I beleive all of tablespace creations fail. and every other action also fails -- i.e. all import actions are failing.
I see that impdp has a remap_tablespace instruction but I should not have to remap every single tablespace in the database to get this to work. I really suspect that this is merely a symptom of the issue and not the problem itself.
One last word -- the export was done with the FULL=YES and the dumb file and log names, with the proper privileges.
Any ideas?