I am trying to export a full database from one platform and Import it on to another. They are both using the same version of Oracle on the same version of linux. The one I am exporting from has two databases on it dev and test. The other machine has a database called devtest. I want to import the dev to devtest. I cannot find any docs on what has to be set up to do this. Do I need to set up the tablespaces or let the import do this? Does this cause any problems with the systems tablespaces, Aux and other tablespaces already on it . The exported tablespaces are on /u02/oradata/dev the other is /u02/oradata/devtest.
Thanks for your help
I probably should have said this is using DataPumps export and I see nothing in the utilites manual about
imp has the option fromuser= touser= option.
I am sure someone has exported a database to another Instance before...
1. Create the database on the other machine (as you have done)
2. Create the tablespaces on the other machine to match my existing DB
3. Create the User(s) that I am going to pull the data into
4. Export the Schemas from the "live" db and import them into the New db.
.... If you have a FULL db export, then you can create ALL schemas on
the new db and import the schemas one at a time with fromuser= touser=
As stated above, if you don't have the tablespaces already created on the
new database, the import will attempt to create those tablespaces in the
same directory structure that they are in on the "live" machine ...
Another related question.
How do you export a database at a earlier version level of export for someone that cant read your export because they are at a different level?
We have export V10.01.00 they are at V9.02.00