Re: How to make a copy of an Oracle DB?

"(Pete Cresswell)" <x_at_y.z> wrote:

>RE/
>>The easy part: run a simple export (from the db server) of the db
>>schema the developers use. Import the schema into your local database.
>>
>>The only problem here could be with data volumes - e.g. when exporting
>>history/audit tables that is 100x the live table size. In which case
>>only import the definition of the table (i.e. having export create it
>>without loading the data).
>
>Is there going to be an OS issue? The "real" DB is running on a Sun/Unix.
>The Personal version would be running under Windows 2000.
>-----------------------
>PeteCresswell

No, export and import are basically OS independent - The only issue is in transporting the DMP file from the Unix to the Windows system ( use BINARY mode ftp, not Ascii ).

( also, be sure to use the same version of EXP and IMP to avoid compatibility issues). Received on Tue Sep 09 2003 - 11:13:51 CDT