| Author |
Message |
dhivakarram
New User
Joined: 27 Jul 2006
Posts: 4
Location: chennai
|
|
|
|
how to unload a partitioned table, partition by partition, if it contains 30 partition i have to unload it in 30 files. everything is done by using symbolic parameters. but how to code the parm card.
kindly help me to learn this |
|
| Back to top |
|
 |
References
|
 Posted: Tue Jun 19, 2007 10:45 am Post subject: Re: How to unload a partitioned table, partition by partition |
|
|
|
|
wanderer
Active User
Joined: 05 Feb 2007
Posts: 139
Location: Sri Lanka
|
|
|
|
Something like this should get you started.
TEMPLATE UNLDDS DSN &USERID..&DB..&TS..P&PART..SYSREC
UNIT SYSDA DISP (NEW,CATLG,CATLG) SPACE (2,1) CYL
UNLOAD TABLESPACE TDB1.TSP1
UNLDDN UNLDDS
Please check the Unload and Template chapters in Utility Guide listed under the link 'Manual' above for more details. Hope this helps. |
|
| Back to top |
|
|
|
|
