Re: Database Cloning

This is extremely unlikely to work across platforms. as different logical data structures often change into different byte sets with different byte orders as you do the move. Have a look at v$type_size for an indication of how different the two platforms may be.

One possible, but tedious, option that can be faster than export/import is to set up database links between the two databases and execute:

    create table xyz
    nologging etc.
    as
    select * from xyz_at_sun_database;

Then do an export/import of structure to sort out privileges etc.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

wteague_at_my-deja.com wrote in message <8rkq8a$c6p$1_at_nnrp1.deja.com>...


>I am trying to port a database existing on a Sun server to a HP server.

>

>The steps I followed are :

>

> 1) Do the Alter database backup control file to trace from the 1st

> database.

> 2) Shutdown the 1st Database

> 3) Copy all the database files and log files to the new directory

>structures on HP server using FTP.

> 4) Modify the init.ora of the 2nd instance to specify the db_name etc.

> 5) Change the trace file generated by control file to trace utility to

> specify the new db_name (same as the init.ora of the 2nd database)

>and  new directory structures.

> 6) Startup Nomount the 2nd instance.

> 7) Execute the control file trace script

> 8) After I enter command 'alter database open resetlogs' I

>consistently get the error:  ORA-01578: Oracle data block corrupted

>(file # , block # )

>

>Any suggestions?

>

>Thanks

>

>Wade

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.