-
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
-
wow, 10 Gb and not partitionned ???
-
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
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|