restoring a schema

From: Isabel <istalcup_at_hotmail.com>
Date: 8 Jan 2007 16:00:45 -0800
Message-ID: <1168300845.527538.326190@i15g2000cwa.googlegroups.com>

Hi all,
Here is the scenerio,

I want to back up a schema from one 10g db to another 10g db. The schema has 3 tablespaces in it. First, I tried the export utility
(exporting by schema, tablespaces, tables...) Everything that got
imported ended up wrong (inside the wrong schema, wrong info, errors, etc...)

I then tried transportable tables and was successful at creating the .DMP and the .dbf's but I could not import them into the new database.
(something about unable to read the log file on a certain line)

My question is which way would you suggest is the best to export a schema that contains a user and 3 tablespaces and reimport to a new 10g database? Once I know the right way then I can worry about fixing the bugs!

Thank you! Received on Mon Jan 08 2007 - 18:00:45 CST