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