View previous topic :: View next topic
|
Author |
Message |
dhivakarram
New User
Joined: 27 Jul 2006 Posts: 5 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 |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 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 |
|
|
|