partition table & indexes

[PSoni]

hi all,


We have created a user specifying default tablespace.
when we are importing data from dmp, we noticed that
some of the indexes and partition tables are inserted
in the SYSTEM tablespace instead of default tablespace.

For our original data, from which we had taken dmp.
We had created user and specified default tablespace.
but during table creation (we are using partition table)
we didn't specify tablespace. where is the problem?? and what is solution to get back indexes and tablespace into default tablespace without recreating table.


awaiting ur replies
thanks

[akhadar]

This has been discussed lot of times.

Check this post

http://www.dbasupport.com/forums/sho...ghlight=export

[SANJAY_G]

Originally posted by PSoni
and what is solution to get back indexes and tablespace into default tablespace without recreating table.


awaiting ur replies
thanks

ALTER TABLE MOVE...
ALTER INDEX REBUID ONLINE....