Today, the field person reports that the report is less than the error. It is a problem with the user-level EXP that is used by the current user. According to the situation in the scene, the problem has been repeated.
D: / Temp> Exp Parfile = Exp.par
Export: Release 9.2.0.5.0 - Production on Tue Dec 21 22:27:13 2004
CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.
Exp-00008: Oracle Error 1031 Encounteredora-01031: Insufficient Privilegesexp-00000: Export Terminated UnsuccessFully
Wherein exp.par reads as follows: userid = scott / tigerfile = / scott.dmpindexes = ygrants = yrows = yconstraints = yowner = scottdirect = ncompress = nfeedback = 10000resumable = yresumable_timeout = 7200log = / export.log..
No problem found, I want to take a trace to capture the incidence of errors, so I decided to use ErrorStack Event. Since Exp is directly executed in the command line, you can only make TRACE for the entire database system. "
Then re-run Exp, still report error, then generate trace files in the udump directory, check the contents of the file, discovery: *** session ID: (15.210) 2004-12-21 22: 22: 36.704 *** 2004-12 -21 22: 22: 36.704ksedmp: Internal OR Fatal Errorora-01031: InsufFicient Privilegescurrent SQL Statement for this session: Alter Session Enable Resumable Timeout 7200
The original problem is in the enable resumable section, this is a new feature of 9i, which is used to hang the entire operation to wait for the operator to solve the space problem when there is a problem with the short space.
As long as the problem is confirmed, it is very well solved. In fact, if you have seen the Adminitrator document in detail, you will not make this error, the Enabling and Disabling Resumable Space Allocation section is clearly written: If you want to use the Resumpale feature, Then there must be Resumable system permissions.
Check the permissions of the on-site user and find only CONNECT and Resource permissions. So: Grant Resumable to UserName;
Of course, if the user is always with a DBA role, then this error will never happen because the DBA role has an eSumable system authority. However, for security, our users will have DBA permissions.
The method of solving the problem is very simple, nothing to say, this article is also a means of discovering problems, that is, the use of set events. This method often becomes a lighting lamp when we feel inexplicably for a mistake. About the author: Zhang Lezhen, the net name Kamus has served by the ITPUB Oracle Certification, the current ITPub Oracle Management Master. He is currently working in a large software company in Beijing, chief DBA, mainly responsible for the management and maintenance of the core trading system of the country of the securities industry. Eat paying attention to Oracle technology and other related technologies, out of the major database technology forums, currently the largest Oracle technology forum www.itpub.net database management version of the Lord. Read more technical articles and essays can log in to my personal blog. http://blog.dbform.com.
