Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: error creating database from template ( NT/9.0.1 to linux/9.2.0.1 .0)

Re: error creating database from template ( NT/9.0.1 to linux/9.2.0.1 .0)

From: Hemal Pandya <h00_at_hotmail.com>
Date: Fri, 04 Apr 2003 15:02:15 GMT
Message-ID: <pan.2003.04.04.15.02.14.95986@hotmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US