| what is a CTAS in oracle [message #3019] |
Fri, 30 August 2002 03:48  |
Lena
Messages: 17
Registered: August 2002
|
Junior Member |
|
|
Can someone please tell me what is a CTAS in oracle what does it do?
How do we preform a ctas and make sure that triggers also come over from the other database.
ALso how can I setup monitoring jobs for free space thresholds
Any help would be great
|
|
|
|
| Re: what is a CTAS in oracle [message #3024 is a reply to message #3019] |
Fri, 30 August 2002 08:27  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
Create Table As Select (CTAS)
create table new_table as
select * from old_table;
The easiest way would be to not use CTAS but to instead use the EXP/IMP utilities which will bring the table (and optionally the data) and any associated triggers.
If you do a CTAS, you will have to manually "copy" the trigger code (extract source/recompile, use TOAD or similar product, etc.).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
