| Parttioned table back [message #537541] |
Thu, 29 December 2011 04:01  |
 |
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
|
Senior Member |
|
|
Hi,
I am not able to take backup of table which is partitioned.Whenever i start the backup
it was hanging with wait event "asynch descriptor resize", so I tried to create another table
using original table ( like create table BASE_TABLE AS SELECT * FROM BASE_TABLE),
but it is also hanging with same wait event.
Can anybody suggest me how to resolve this issue ?
[Updated on: Thu, 29 December 2011 04:02] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Parttioned table back [message #537660 is a reply to message #537580] |
Fri, 30 December 2011 02:17  |
|
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
|
Senior Member |
|
|
This issue is resolved.
I use the below command which got hang in the middle but later it ran successfully after adding
parameter direct=y at the end of the export command.
exp system/pwd statistics=none indexes=N buffer=104857600 rows=Y
feedback=1000000 constraints=N grants=N tables=JACK.BASE_TABLE
[Updated on: Fri, 30 December 2011 03:34] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
