Export problem. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Export problem.

  1. #11
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    hi,

    try exporting that problematic table (STREET_NJ) alone.

    whether it is the problem with the table or not.

  2. #12
    Join Date
    Aug 2000
    Posts
    25
    It would be total of more then 5gig ( 6 gig aprox ) once I finish exporting all tables.

    I will try compress method.

    Thanks for your help.

  3. #13
    Join Date
    Aug 2000
    Posts
    25
    exporting that problematic table (STREET_NJ) alone works fine.Problem start when I try a full dadabase export.

    Thanks
    Last edited by Puja; 12-04-2003 at 09:01 AM.

  4. #14
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Puja,
    try exporting to a compressed pipe(inline compression). I think that will solve your problem. Keep in mind that if you have partitions its much easier to perorm partition exports..
    "High Salaries = Happiness = Project Success."

  5. #15
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Originally posted by Puja
    It would be total of more then 5gig ( 6 gig aprox ) once I finish exporting all tables.

    I will try compress method.

    Thanks for your help.
    I was asking you the size of the export file when the export fails. Refer the links I gave, you will get the scripts to compress or compress and split.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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