dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import/Export

  1. #1
    Join Date
    Feb 2002
    Posts
    18
    I need to import a database which has a large number of Integrity constraints.(Indexes,foreign keys ect).I need to import the data as well.I know If I do a full export and then do a simple imort its going to take agaes to build the indexes.What would be the best possible solution while importing?

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    you can avoid indexes by saying index=N While u perfrom import.Then u can re-create the indexes after importing the data.

    cheese
    anandkl
    anandkl

  3. #3
    Join Date
    Feb 2002
    Posts
    18
    Should I use the indexfile option during import to get the syntax for creating indexes??Also I need to import the data,so should I specify rows=Y during import

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    you dont need to specify rows=y because by default the parameter rows will be bet to 'Y'.No need to use the indexfile option.

    cheese
    anandkl
    anandkl

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