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

Thread: Export problem.

  1. #1
    Join Date
    Apr 2001
    Posts
    3

    Post

    Hi,

    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
    Posts
    1
    HI
    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
    Location
    Scotland
    Posts
    200
    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

    Alison

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