-
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]
-
Hello
What version of oracle are you using ?
regards
Hrishy
-
Originally posted by hrishy
Hello
What version of oracle are you using ?
regards
Hrishy
I am using Oracle 8i standart edition
Daniel
-
why don't you use the data manager/ thru OEM.??
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Re
Originally posted by Tarry
why don't you use the data manager/ thru OEM.??
I do not have it installed on the computer
Daniel
-
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
-
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
anandkl
-
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.
Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|