Re: How to do system copy by export/import of a SAP database

hey Belinda,

1st create the TST db - create script u have to make yourself.

   but that's easy to find. Get your sizing for tablespaces correct,   or make it Autoextend.

Then import the export file ; options:

   full=Y file=X.dmp buffer=500000 commit=Y log=impx.log

If your tablespaces don't exist import will make file & tablespaces identical to what you had. Otherwise u get and error which u can ignore. So the best way is to create the correct tablespaces first.

Create scripts example on: www.bytelife.com/sql4dba.htm

cheers

     Roelof Schierbeek

R.Schierbeek, DBA
e-mail: info_at_bytenspmlife.com
www : www.bytelife.com

Belinda <belindacur_at_yahoo.com> schreef in > Hi All
>
> I want to do make a copy of our development SAP system running on
> Oracle 817 called DEV to another system called TST. I want to use the
> Oracle
> export and import utility to create a full dump of DEV and import this
> to TST.
>
> I cannot use a backup and restore of DEV to TST since the space on TST
> is smaller than DEV. But there is lot of unused space in DEV. TST
> already as a
> oracle database I have shut the oracle instance on TST and deleted all
> the data files, redo log files and control files. How can I now import
> the dump from DEV to TST can I make Oracle to create the
> instance/database on TST and then import the contents of DEV into TST.
> Please provide me some advice on this. If possible if you have some
> scripts for the same.
>
> Thanks
> Belinda
Received on Wed Feb 12 2003 - 13:25:55 CST