ravi17s Warnings : 1 New User
Joined: 15 Aug 2003 Posts: 57
|
|
|
|
If you have an IMAGE copy you can Unload image copy and then load replace the table,but make sure that the tablesspace contains only one table.This is an BMC stuff.
Method 1:
UNLOAD
INFILE IMAGECOPY
UNLOADDN SYSREC ACTIVE(YES, NO)
SHRLEVEL CHANGE
CNTLDDN CNTL0001 SORTNUM 32
OUTPUT SYSREC
DSNAME 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
SPACE (100,500) UNIT SYSDA
ORDER NO
the CNTL0001 will contain the load control card you require.
Method 2:
RECOVER TABLESPACE xxxxxx.xxxxx
INCOPY
FULL DSNAME XXXXXXXXXXXXXXXXXXXXXX
SHRLEVEL REFERENCE
OUTCOPY YES OUTCOPYDDN LOCALP
TOCOPY LASTCOPY
My best sugestion would be to contact your DBA,they are always their to help you.
Thanks,
Ravi |
|