exporting database did not export default column values 
Author Message
 exporting database did not export default column values
Hi,

I moved a simple database the other day using Oracle 8i's
export/import utilities from one instance to another.  Everything was
moved successfully (i.e. tables, data, constraints, etc.) except for
default column values, which didn't appear in the new instnace.  Did I
miss a step in the process or is there something about default column
values that Oracle doesn't do?

Any insight would be greatly appreciated.  Default parameters were
used for the export and import.

Sam



Mon, 24 May 2004 02:23:29 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DTS Export: How to have nulls export as blanks on fixed width export

2. DTS Export does not export all FK props???

3. Defaults not exported in DTS

4. exporting and exporting OFA databases.

5. bcp queryout not exporting more columns

6. Default Column Value Does not Replicate

7. Transform Data Task not using default value in destination column

8. default value on not nullable column

9. How to set a column not using default value

10. Export Null values to Excel cause left shifted values in XLS

11. IGNORE: column default value lost in copied database

12. column default value lost in copied database


 
Powered by phpBB® Forum Software