NOT NULL after import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: NOT NULL after import

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    NOT NULL after import

    I just did an import. After the import I compared the database structure of the source db (where the export was taken from) and the target db (where I did import into).

    There's a couple of tables where a few of it's column got NOT NULL after it got imported into the target db (where it did NOT have NOT NULL in the source).

    I haven't done very much exporting and importing. Is this common occurence and an someone explain why.

    BTW: Verison is 9205.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    What type of import did you do?
    Were the structures in place prior to the import?
    I remember when this place was cool.

  3. #3
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    I did a full export from the source.

    Then I did an import schema by schema (using fromuser-touser, becuase I didn't want to import certain schemas).

    And NO, no structure (other than the default from a clean installation of a new instance) were in place in the target db prior to importing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width