I have a user whose default tablespace is SYSTEM,
when i export it and import it into another database again
it gets imported into the same system tablespace.(although
the default tablespace of that new user is USERS)
here is the question:
How can i change the tablespace for a particular user if
the exported user;s tablerspace is SYSTEM. Or u can
say How can i change the schema;s tablespace.? so that whole of
that schema's objects gets into another tablespace?
when i export it and import it into another database again
it gets imported into the same system tablespace.(although
the default tablespace of that new user is USERS)
here is the question:
How can i change the tablespace for a particular user if
the exported user;s tablerspace is SYSTEM. Or u can
say How can i change the schema;s tablespace.? so that whole of
that schema's objects gets into another tablespace?