Re: Copy database in Oracle 8.1.6

"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