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

Title: full exp/imp of user to new tablespace; same user ifyou have toimport all indexes,constraints to a single tablespacethenfollowing procedurewillwork 4)After importing datachange the default tablespace to index tablespace ,ensure that no other ts quota(except index ts) is given

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

Title: full exp/imp of user to new tablespace; same user oh - I like that! thanks! -Original Message-From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]]Sent: Friday, November 08, 2002 2:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp

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

Title: RE: full exp/imp of user to new tablespace; same user A quick note to those that downloaded a version of DBATool yesterday following on from my message, and to all those that have a past version as well. The download link on the DBATool web page hadn't been updated for the new

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

Title: full exp/imp of user to new tablespace; same user Choudhary out of curiousity, is itunderstood that you will need todrop the same recently imported indexes from the data TS before running the import into the index TS ? or will subsequent import cause a rebuild on the incoming

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

Title: 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

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

Markham, Richard wrote: 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;

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

Title: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure

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

-Original Message- 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;

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

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:59To: Multiple recipients of list ORACLE-LSubject

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

And if all else fails (not that the advice already given will!), we have a tool that can manipulate the DDL for the users objects VERY quickly and easily, through a rule based change (e.g. Modify ALL tables storage clauses within USERS schema to TABLESPACE):

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

Title: RE: full exp/imp of user to new tablespace; same user well now I can say I'm spoiled. I was given more than enough information to to accomplish the task (done) and a new tool to boot! =) Thanks alot everyone. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED

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

: [EMAIL PROTECTED] Subject: RE: full exp/imp of user to new tablespace; same user