Re: move database to new server/directory

What's in a namespace (xml_at_ns.com) wrote:

> OK! I feared this was a production situation.

No, it's a playground.

> Export/Import should not depend on ORACLE_HOME settings, so that can't
> be te reason for the failure.
> Which exact steps did you take to do the export/import?

exp file=d:\export.dat full=yes log=d:\export.log No errors, no warnings.

> What do you mean by 'All the config?' (specially when the directories are
> different, the original uses separate directories for installation and
> data, the copy doesn't (yet))

I played around and made some settings like defining a mailrelay or a backup plan. Nothing important but I'd like to know if that data could be exported, too.

> How many database schemas are involved? How much data? Could a default
> installation and one user export/import do the job?

I'm not a hundred percent sure how a "schema" is defined, but I have two custom table spaces and one database user. The dumpfile has a size of 160MB.

Then I move the export file to the new server and: imp file=d:\export.dat full=yes log=d:\import.log

The error log says:

IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'D:\ORADATA\ORCL\MYDB.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file

On the new server $ORADATA is D:\oracle\product\10.2.0\oradata\orcl and not D:\oradata\orcl

Helmut

-- 
Please do not feed my mailbox, Swen still does his job well