Oracle Database Discussions

Hi guys

I have a table in which there are default values for some columns. I take export of this table.

I go to another database where this table structure is already there (but default values are not set). I run the import of table with ignore=Y. It does all...import the data...create the indexes and all...but doesn't set the default values for the columns.

Shouldn't it do that also ? ignore=Y means that ignore the object creation errors and proceed with the rest of the stuff ? Or there is some problem in my understanding ?

Version 10gR2 on AIX 5.3 and using traditional export/import.

Thanks

Amardeep Sidhu