ORA-39002
ORA-39070
ORA-29283
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283
Check out expdp with default directory.If this ok.Then check out drive security.There is no SYSTEM user in SECURITY Tab.Add system user to SECURITY.Then try.
Cheers!!!
Thursday, April 21, 2011
Tuesday, April 5, 2011
ORA-01000 maximum open cursors exceeded
Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;
Try to find out application to see why cursors are staying open.
Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;
Try to find out application to see why cursors are staying open.
Subscribe to:
Posts (Atom)