RE: full exp/imp of user to new tablespace; same user

[Jack van Zanen]

Title: full exp/imp of user to new tablespace; same user

Extra security could be to give zero quota on other tablespaces.

-----Original Message-----
From: Markham, Richard [mailto:[EMAIL PROTECTED]]
Sent: donderdag 7 november 2002 14:59
To: Multiple recipients of list ORACLE-L
Subject: full exp/imp of user to new tablespace; same user

I have a full export of user to where I need to import all his objects/grants
but into a NEW tablespace.  What's the easiest way I can assure that
~everything~ is imported.  Will I need to use a combination of INDEXFILE
and other procedures or will a full export; drop tablespace; create new
tablespace; alter user's default tablespace; full import suffice for
all objects? Thanks for any tips.