Export problem.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Export problem.

  1. #1
    Join Date
    Apr 2001



    I'm tried to impot one file. This file contains the data of thirty tables and some these tables has huge data. But after importing three tables it is not doing anything just hanging for a long time. showing this message "importing table ". The size of the export file is 1.8 gb. Prevoiuslu i have imported those tables in another database and there it was successful. Can you clarify why it is not doing anything ?

  2. #2
    Join Date
    Mar 2001
    have u checked that if the maxextents condtion has been reached while importing
    Do u have sufficent space in the tablespace to import all the data add more space to the datafiles and do it again.

  3. #3
    Join Date
    Feb 2001
    Hi there,

    After the tables has imported it then imports/creates and indexes associated with that table.

    If the table is huge as you say this could take some time.

    For example I imported a table with 5 million rows, the associated index took well over an hour to create, this shows in the log as

    . . importing table "EV_CLOSING" 5661514 rows imported

    It moves onto the next table once the index has finished.

    Hope this helps


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