db cloning question: no response last time

[jlakhani]

I installed 8i on linux yesterday at Digiship. I have created a database called DSDEV. and as you know the installer creates some datafiles system, user01, temp01 etc. dbf files. The user wants me to copy over the data from another instance to DSDEV. How do i copy over the datafiles and get the database up and running?

[mallard]

You could probably use import/export or SQL Loader either one.

[jlakhani]

yes but import export wont copy files over.

[Kishore]

You cannot copy datafiles from DB to another.

You can only move data from one to another.

[jlakhani]

ok....see export will copy database structures and you can import them to another instance.,
but what about copying the datafiles them to another instnace?

[mallard]

I'm not sure about this, so someone please verify. Wouldn't you just create new datafiles, etc when creating the new database. Then, using export/import, copy over the table structures, data, indexes, triggers, etc.

[Kishore]

There is no way to copy Datafiles from Once Db to another. Only the way is to create that new Db, export from Old to new.

[rcaballe]

Search the term transportables tablespaces.
This way you can "unplug" a fully contained tablespace and plug it into the new database.
Interesting, right?

[tamilselvan]

Threre are many ways you can copy data from one schema to another schema in another instance.

1 Export/Import at user level

2 Use COPY command with db link

3 Use SQL*LOADER

4 Use DB cloning method if you want to create duplicate DB.

5 Use Multimaster Replication so that every transaction is copied from one instance to another instance. Use Active/Passive option.