Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: error creating database from template ( NT/9.0.1 to linux/9.2.0.1 .0)
On Fri, 04 Apr 2003 05:14:45 +0000, Hemal Pandya wrote:
> Thanks a lot for your help Norman, I think I am set for now.
Ouch. Spoke too soon.
[....]
> Meanwhile, I also found out that I don't really need to create the
> tablespaces or the users to be able to restore from the dump file, all I
> need is a database, which I can create using dbca and then an export
> file created with FULL=Y when imported creates the users as well.
[....]
I just realized that the exported dump file has hard-coded full paths for tablespace files (CREATE TABLESPACE "INDX" BLOCKSIZE 8192 DATAFILE 'D:\ORACLE\ORADATA\TESTDB3\INDX01.DBF' ....) resulting in files with names starting with $ORA_HOME/dbs/D:. The database is functional, so I can do my programming against this database, but I would like to make it 'correct' if I can.
Should/Can I modify the paths directly in the dump file? Is the DIRECT parameter for exp related to this issue? Is TRANSPORT_TABLESPACE? Can I move the tablespace files to correct name and location after importing the database? Received on Fri Apr 04 2003 - 09:02:15 CST