export into a different tablespace

Hi friends,
I have tables in user1 tablespace and i want to move it into a different database on to a new tablespace user2...

Please help me on this....

regards
anandkl

Use ALTER TABLE MOVE clause if its 8i

http://www.dbasupport.com/forums/sho...threadid=25992

yes what sreddy is said is right.

There is another alternate way i guess correct me if i am wrong.

Find out who are the users for that user1 tablespace.
Export those users
Where u have different database create those users and then import it back with the clause fromuser , touser

--pravin

I need to export it to a new database..on to a new tablespace..


regards
anandkl

I just posted the export backup solution in ur case.

Pravin

when i export it into the new database..i am getting error
'tablespace user1 not found'

The tablespace i want the tables to be moved is user2

regards
anandkl

If your tablespace name is different from original tablespace in the new database. First create empty table in new database in the tablespace you wanted and then import with the option ignore=y.

Quote:

---

Originally posted by anandkl
when i export it into the new database..i am getting error
'tablespace user1 not found'

The tablespace i want the tables to be moved is user2

regards
anandkl

---

change you user's default tablespace to user2 before import and make sure he hasnt got unlimited tablespace priv

Otherwise,
Use indexfile option in export, create an indexfile, convert into txt file, edit the tablespace name and then save it as SQL, and then execute this file in your target DB. Its simpler if your export dump file is smaller in size. Folks, Please correct me if i'm wrong.

boss export solution is the only best way in ur case.

U can try other alternatives if u have ease of time and no emergency in this case.

If you are moving all the tables in the tablesapce use TRANSPORT_TABLESPACE. It is faster and easier. But you will have to make sure that the tablesapce is self-contained.

Sanjay