I agree with the owner export of the schema and using the fromuser
touser clauses in the import utility. One may want to consider creating
the new tablespace and the new user before importing the data. Don't
drop the old user cascade, or the old tablespace including contents
cascade constraints, until the new user has been fully tested. This may
require all grants references and cross schema constraints to be aligned
properly. Running the utlrp tool as sys should recompile any invalid
objects.

Regards,
Ed Bowers

-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x40938145.[Email address protected]
Sent: Thursday, June 02, 2005 6:28 AM
To: LazyDBA Discussion
Subject: Re: Renaming Schema in Oracle

Using the good old export/import with fromuser touser option is about
it...

Mike Porter
Finance Support Services
PGA of America
561-624-7646
>>> "Srinivas Shesham " <oracledba-ezmlmshield-x45789329.[Email address
protected] 06/02/05 00:11 AM >>>
Hi,



Is it possible to rename an existing schema in Oracle 9i.



Thankyou in advance



Cheers,
Srinivas Shesham







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page