Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: IMP/EXP entire db to new location
The easiest way is to do two exports. The first is a definition of the database (ROWS=N in the parmfile). The second is the full export (ROWS=Y in the parmfile).
You then import the definition file into the 'virgin' database to create the tablespaces and objects. Once this is done you can import the data from the second export.
In article <357f7b9d.32224434_at_203.14.37.254>,
mahoneyc_at_mh.adi-ltd.com.au (Chris Mahoney) wrote:
>
> I need to migrate our current production database to a new server.
>
> The new server has a virgin installation of Oracle 7.3.3.
>
> I believe it is possible to create a script that will export the
> entire database including the schema, and you are then able to import
> this into the new location, and it will create the tablespace, the
> databases and then populate them?
>
> Is this correct? If not, what must be done to complete this task?
>
> Thanks in advance,
> Chris
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 12 1998 - 00:00:00 CDT