Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copying v8.1.5 NT Database to 10g Win2003 Server?

Re: Copying v8.1.5 NT Database to 10g Win2003 Server?

From: Dave <x_at_x.com>
Date: Mon, 29 Nov 2004 22:49:47 GMT
Message-ID: <fINqd.26060$up1.24757@text.news.blueyonder.co.uk>

"SAP BASIS Consultant" <basis_consultant_at_hotmail.com> wrote in message news:dd2036f3.0411291436.39ad4650_at_posting.google.com...
> Hello,
>
> I installed Oracle 10g on Win2003. I created a database with the same
> name (Say TEST) as a v8.1.5/NT database on another server. I used a
> similar init<SID>.ora for both databases, though I had to adapt some
> parameters such as 'compatible', 'log_archive_format', pool sizes
> etc.. for 10g. (The control files and rollbacks are the same for 10g
> and 8i).
>
> I created the same tablespaces (With the same sizes and datafiles)
> and rollback segments (Sorry for those of you who cringe at the
> words 'rollback segments' and 10g in the same sentence) in 10g as
> in 8i, with the addition of SYSAUX in 10g.
>
> I also created the same Windows directory structure for Oracle in
> Win2003 (10g) as in NT (8i), and adapted the necessary env.
> variables and/or registry parameters. 'listener.ora' and
> 'tnsnames.ora' have also succesfully been adapted.
>
> Will I be able to do a straight copy of the source 8i files into
> the target 10g Oracle directory structure, and reset the logs
> in the target 10g database when opening it?
>
> I realize that an export/import may be more straightforward, but
> the server hosting the source 8i database may not have the disk
> space necessary for an export.
>
>
>
>
> Thanks,
> SAP BASIS Consultant

not a chance- made by different versions of the software, different headers different everything - scns will be out of sync

seriously, it wont work

do export over your network or set up a dblink Received on Mon Nov 29 2004 - 16:49:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US