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

Thread: export of a bulk table

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149

    Exclamation

    I have one queruy.

    I have one table of 10GB size.
    can my database is able to do export of that table.

    Pls sugest what will be the procedure

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    wow, 10 Gb and not partitionned ???

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    If u want to take a export of the table which is 10GB in size then i think that u should

    exp sys@plan_mts file=a.dmp log=a.log tables=user.bigtable
    indexes=y rows=y consistent=y(read only view from rollback segment) statistics=none
    compress=N constraints=y
    direct=y(bypasses SQL command Processing Layer)


    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com





    Originally posted by pareshg
    I have one queruy.

    I have one table of 10GB size.
    can my database is able to do export of that table.

    Pls sugest what will be the procedure

  4. #4
    Join Date
    May 2001
    Location
    London
    Posts
    149

    Thumbs up

    thanks for ur reply

    Paresh

    Originally posted by rohitsn
    Hi,
    If u want to take a export of the table which is 10GB in size then i think that u should

    exp sys@plan_mts file=a.dmp log=a.log tables=user.bigtable
    indexes=y rows=y consistent=y(read only view from rollback segment) statistics=none
    compress=N constraints=y
    direct=y(bypasses SQL command Processing Layer)


    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com





    Originally posted by pareshg
    I have one queruy.

    I have one table of 10GB size.
    can my database is able to do export of that table.

    Pls sugest what will be the procedure

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Most of the OS wil not support > 2 GB file size. To split the dump file, you need to use filesize parameter in the exp command.

  6. #6
    Join Date
    Jan 2001
    Posts
    642
    I do an export of few of my tables daily, which are as big as 6GB.I use the direct =y option and put them in a partition where there is about 12GB disk space.

    I do the exports of such big tables every day as a backup strategy. I cannot put these tables into archive mode as the redo logs will fillup the file system.



    exp file=exp_${ORACLE_SID}_${expdate}.dmp Tables=rei_usage_history consistent=y direct=y statistics=none log= /u01/app/oracle/product/8.1.6/admin/rel/exp/logs/exp_${ORALCE_SID}_${expdate}.log>/dev/null 2>&1


    This works
    badrinath


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