Re: create table as (can you keep column default data?)

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 03 Oct 1998 13:57:07 GMT
Message-ID: <36182d13.3676176@192.86.155.100>

A copy of this was sent to "Arthur" <art_lewis_at_hotmail.com> (if that email address didn't require changing) On Fri, 2 Oct 1998 21:47:17 -0400, you wrote:

>Is there a way when migrating tables from one db to another (local or
>remote) to maintain the default data setting of the source table.?
>
>
>

If you use the tools exp and imp (export and import) then yes -- you can. Using straight SQL command (create table ... as select ....) you cannot.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Oct 03 1998 - 08:57:07 CDT