There is no magic command, but you can use export/import to accomplish a
rename of a schema.....

1. Export current schema
2. Create new schema user
3. Import file from step 1 into user created in step 2.

HTH

(Bill Lusk) wrote:
> Can a schema be renamed in an Oracle 10g database? And if so, what is the command?
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>




Oracle LazyDBA home page