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

Thread: TRANSPORTABLE TABLESPACE

  1. #1
    Join Date
    Aug 2001
    Posts
    134
    When i perform export on a table it takes 12 minutes, and file size is 100MB.
    when i perform import same table it takes 32 minutes, and file size is 4GB.

    But when i exp through transport tablespace it takes only 20 seconds on metadata
    (one tablespace) or (one table mentioned above), and file copy and paste take 70 minutes.

    >exp tarnsport_tablespace = y tablespaces = (abc) file = abc.dmp userid = 'sys as sysdba'
    direct = y

    How we can say that transport tablespace is much faster than simple exp-emp ?
    or i miss a point ?


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that is your disk problems.... 4GB in our system probably takes 10 minutes

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