import and export schema

[4daniel]

I need to use import and export feature to transfer a schema from one tablespace to another. I am using Sql*Plus, and I need the correct process, plese include the actual sql request
Thx in advance,
Daniel

I am using Oracle 8i standart edition



[Edited by 4daniel on 04-09-2002 at 04:25 AM]

[hrishy]

Hello

What version of oracle are you using ?

regards
Hrishy

[4daniel]

Originally posted by hrishy
Hello

What version of oracle are you using ?

regards
Hrishy

I am using Oracle 8i standart edition
Daniel

[Tarry]

why don't you use the data manager/ thru OEM.??

[4daniel]

Originally posted by Tarry
why don't you use the data manager/ thru OEM.??

I do not have it installed on the computer
Daniel

[aarroyob]

As you are working with 8i, why don't you use the alter table move for changing the tablespace for this schema?

1. Create a new tablespace and give quote to the owner
2. Connect as the owner of tables
3. spool move_tables
select 'alter table '||table_name||' move tablespace new_tablespace;'
from user_tables;

spool off
4. Execute with this user the script move_tables
5. Change the default tablespace for this user to the new TB.
6. Recreate the indexes

I think I don't forget anything

Cheers

Angel

[anandkl]

what u can do is do the export.
exp username/password@service_name file=
owner=schema name

Then open the export file.Search for word tablespace,replace the name of the tablespace with the new tablespace created and then do the import.

before doing the import create the new tablespace and make this the default tablespace for the user.

cheese
anandkl

[brhynold]

From my experience opening and editing a export dump in a text editor will corrupt the dump file.

You can try this

1. Export the schema
2. Change the user's default tablespace to the new tablespace
3. Remove any quota the user had on the old tablespace
4. Import the schema

If the user has no quota on the tablespace specified in the export file then the objects are created in the user's default tablespace.

[aarroyob]

I repeat, the easiest way is move the tables from one tablespace to another, and then recreate the indexes in the tablespace you want.

Regards

Angel