How to consulate data files in original import?
Hi,
I'm currently working on a project to import an aging Oracle 9i database (currently running on Solaris 11) to a new Oracle 12c database (running Oracle Linux 7).
The goal is to put the table space data file in different filesystem locations than the 9i database, but the export/import process appears to preserve this.
I am able to do my imp full=y ....
stuff only if I pre-create the same directories that we're on the 9i database host.
Ideally it would be nice if I could pre-create the tablespaces with the datafiles where I want them before the import. Alternatively I'm content to import then move but I'd like to reach out the community first.