| schema transfer [message #50464] |
Sun, 17 March 2002 20:40  |
Rajee
Messages: 17
Registered: June 2001
|
Junior Member |
|
|
Hi,
How to transfer schema owned by an oracle user to another oracle user without using Export/Import utlity.
I need to transfer the entire schema (all schema objects).
Thanks and Regards,
Rajee
|
|
|
|
| Re: schema transfer [message #50467 is a reply to message #50464] |
Sun, 17 March 2002 21:34  |
Manu Gupta
Messages: 44
Registered: January 2002
|
Member |
|
|
|
I would do it by granting "select" privileges to the new user on all objects and then using "create {object} {object_name} as select.....".
|
|
|
|
| Re: schema transfer [message #50469 is a reply to message #50464] |
Sun, 17 March 2002 21:54 |
Rajee
Messages: 17
Registered: June 2001
|
Junior Member |
|
|
Hi,
Thanks for ur immediate reply, gupta.
I think "create {object} {object_name} as select....." query will work for objects like tables, views, indexes, etc. But how to transfer procedures, functions and packages.
Thanks and Regards,
Rajee
|
|
|
|
| Re: schema transfer [message #50471 is a reply to message #50464] |
Sun, 17 March 2002 22:08 |
Carnage
Messages: 9
Registered: March 2002
|
Junior Member |
|
|
Drawback of CTAS
1. If you got through CTAS only "not null" constarints will come ... not primary or unique key will act.
CONSTAINTS ARE LOST.
2. Rollback should be very large( u might me creating huge table )
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
