From: "Hinet News" <Djuro.Dretvic@Infodom.hr>
Newsgroups: comp.databases.oracle.server
Subject: Re: Copy database in Oracle 8.1.6
Date: Wed, 8 Aug 2001 16:38:16 +0200
Organization: Iskon Internet d.d.
Lines: 49
Message-ID: <9krimd$bnc$1@sunce.iskon.hr>
References: <9kotu3$ulm$1@sunce.iskon.hr> <2a676b39.0108070918.3fbee6ee@posting.google.com> <9kr8o8$64v$1@sunce.iskon.hr> <9krb7c$5un$1@ctb-nnrp1.saix.net>
NNTP-Posting-Host: dns1.infodom.hr
X-Trace: sunce.iskon.hr 997281293 12012 213.191.143.122 (8 Aug 2001 14:34:53 GMT)
X-Complaints-To: abuse@iskon.hr
NNTP-Posting-Date: 8 Aug 2001 14:34:53 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


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



"Billy Verreynne" <vslabs@onwe.co.za> wrote in message
news:9krb7c$5un$1@ctb-nnrp1.saix.net...
> "Hinet News" <Djuro.Dretvic@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
>
>
>