Re: Copy database in Oracle 8.1.6

Thank you very much. I understand now.
Regards Djuro.

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:9krb7c$5un$1_at_ctb-nnrp1.saix.net...
> "Hinet News" <Djuro.Dretvic_at_Infodom.hr> wrote
>
> > What about talbespaces ? If I run full database export, are they
 included
> > too, or not ?
>
> Yes and no.
>
> Yes, the tablespace and storage clauses are included to be used for
 re-creating
> the objects (indexes, tables, etc) on the new database.
>
> No, the import will not recreate the tablespace for you.
>
> To import, you need a database already created and configured.
>
> If you want to copy the _physical_ database across, then you need a
 physical
> backup of the complete database. If you have the same file system layout
 on the
> other (destination) machine, no problems. Do the restore and start up the
> database. Should be as simple as that. You will need to change the IP
> address/hostname in the listener.ora file though.
>
> If the file systems are different, then you will need to recreate the
 control
> file(s) on the destination machine. Dump the control file to trace on the
 source
> machine. Do not restore the control files on the destination machine
 (restore
> everything else). Edit the control file recreation script to point to the
> restored files on new filesystems and run that via server manager on the
> destination machine.
>
>
> --
> Billy
>
>
>
Received on Wed Aug 08 2001 - 09:38:16 CDT