Solving common Oracle errors guide

Stumped by an Oracle error? We've compiled a list of every expert response pertaining to Oracle errors on SearchOracle.com. You've already asked the questions, now find the answers quickly and easily in the guide below.

If the error you're dealing with is not listed, or if your dilemma is not specifically addressed, just ask one of our experts for help and we'll add the response to this ever-growing guide to common Oracle errors.

  TABLE OF CONTENTS
   Resources for working with errors
   ORA-00000 - ORA-01999
   ORA-02000 - ORA-03999
   ORA-04000 - ORA-05999
   ORA-06000 - ORA-07999
   ORA-08000 - ORA-11999
   ORA-12000 - ORA-13999
   ORA-14000 - ORA-23999
   ORA-24000 - ORA-25999
   ORA-26000 - ORA-27999
   ORA-28000 - ORA-30100
   Other error messages
   For more information

  General information about working with errors
[ Return to Table of Contents ]

• Where to get a complete list of all ORA errors
• Capturing errors from merge statement
• Perform a check or wait for an error?
• What should monitoring reports identify
• Oracle alert log miner
• Logging the command that caused server error
• Catching error code that arises in PL/SQL
• Advanced error checking using a trigger
• 
  

   

  ---

    ORA-00000 - ORA-01999
  [ Return to Table of Contents ]
  

  ORA-00054: resource busy and acquire with NOWAIT specified
  Solutions:
  

• Is there a way to stop a rollback?
• Error trying to rebuild index after cancelled transaction
• How long does a rollback take?
• Identifying locks to resolve ORA-01658 and ORA-00054 errors

• ORA-00054 error with shell scripts

  ORA-00060: deadlock detected while waiting for resource
  Solutions:
  

• Deadlock error when a specific batch process runs in parallel

  ORA-00200: controlfile could not be created
  Solutions:
  

• Avoiding Oracle errors
• ORA-00235: controlfile fixed table inconsistent due to concurrent update
  Solutions:
  

• Using the RMAN level 0 hot backup process

  ORA-00312: online log string thread string: 'string'
  Solutions:
  

• Errors causing Oracle instance to shut down

• Receiving ORA-313 and ORA-312 errors when trying to open database

  ORA-00313: open failed for members of log group string of thread string
  Solutions:
  

• Receiving ORA-313 and ORA-312 errors when trying to open database

  ORA-00320: can not read file header from log 1 thread 1
  Solutions:
  

• Getting Oracle errors -- database and Web site are down
• ORA-00321: ORACLE_HOME Redo1.log
  Solutions:
  
• Getting Oracle errors -- database and Web site are down

• Errors causing Oracle instance to shut down

  ORA-00381: cannot use both new and old parameters for buffer cache size specification
  Solutions:
  

• Why am I getting the ORA-00381 error when initializing the parameter?
• ORA-00396: error string required fallback to single-pass recovery
  Solutions:
  

• ORA-00396 and ORA-00397 while loading data

  ORA-00397: lost write detected for file string, block string
  Solutions:
  

• ORA-00396 and ORA-00397 while loading data

  ORA-00406: COMPATIBLE parameter needs to be string or greater
  Solutions:
  

• ORA-00406 when trying to create a function index
• ORA-00439: feature not enabled: string
  Solutions:
  
• Creating a table partition
• Managed standby error in ARCHIVE MODE

• Problems with installation of Partitioning

  ORA-00510: internal limit restriction exceeded
  Solutions:
  

• Is the number of processes causing listener error?
• ORA-00600: internal error
  Solutions:
  
• System timing out writing to control file
• Error when updating table in Oracle 8i
• "Disconnection forced" message
• ORA-00604: error occurred at recursive SQL level string
  Solutions:
  
• Table update fails at recursive SQL level 2
• Recursive SQL error when using Web app
• Errors executing Oracle recursive query
• Getting ORA-00604 error when connecting to database user
• ORA-00604: error with recursive SQL

• Unexplained daily errors

  ORA-00903: invalid table name
  Solutions:
  

• Trigger error in SQL*Plus
• ORA-00904: invalid column name
  Solutions:
  
• Error accessing all SQL Server fields in Oracle environment
• Getting invalid column name without access to system tables
• Error viewing records in table that has abstract column datatype
• "Invalid column name" error
• Error on "select timestamp" command

• SQL execution error ORA-00904

  0RA-00922: missing or invalid option
  Solutions:
  

• Substitution variables
• ORA-00932: inconsistent datatypes
  Solutions:
  
• Help creating a script from a view
• UNION of two Oracle8i views with CLOBs
• How to get the lengths of values in "long" datatype

• Unexplained daily errors

  ORA-00942: table or view does not exist
  Solutions:
  

• Export errors on Solaris
• Export errors on Linux
• Oracle9i R1 allows any user to access any table
• Errors with export command

• Unable to select or drop a table

  ORA-00955: name is already used by exsisting object
  Solutions:
  

• Installing the recovery catalog from RMAN prompt
• ORA-00959: tablespace 'string' does not exist
  Solutions:
  
• Importing a table that contains LOB segments
• ORA-00980: synonym translation is no longer valid
  Solutions:
  
• Information on ORA-00980
• ORA-01000: Maximum open cursors exceeded
  Solutions:
  
• Errors executing Oracle recursive query

• ORA-01000 errors on Windows XP

  ORA-01002: fetch out of sequence
  Solutions:
  

• ORA-01002 error when trying to describe a table
• Resolving the ORA-01002 error #1
• Resolving the ORA-01002 error #2
• ORA-01017: Invalid username/password
  Solutions:
  
• Error when trying to restore a specific table
• "Invalid username/password" error
• ORA-01017 error when connecting through Windows XP client

• Unable to log in to database from desktop

  ORA-01031: insufficient privileges
  Solutions:
  

• Trouble inserting large CLOB
• Password file generation
• Creating a function-based index
• "Insufficient privileges" error
• Logging in to a test database

• ORA-01031: insufficient privileges trying to restore a database

  ORA-01033: ORACLE initialization or shutdown in progress
  Solutions:
  

• Database stopped, showing multiple error messages
• Getting ORA-01033 when logging in to 9i application
• Restoring default database in 8i
• Encountering error while cloning a production database
• Initialization or shutdown in progress

• ORA-01033 error when taking backup

  ORA-01034: ORACLE not available
  Solutions:
  

• After starting SQL*Plus after 9i install
• On Linux Fedora Core 2
• When rebooting 9i
• Errors during reboot
• Error accessing database after migration to 9.2.0.3
• Errors connecting Oracle through SQL*Plus
• Domain name changes causing error
• Trouble getting two database instances running
• Error when starting Oracle
• Resolving the ORA-01034 error
• Oracle not available after installing 8i on WinXP Pro
• ORA-01034 after upgrading to version 9.2
• ORA-01034: Oracle not available error
• Resolving the "ORA-01034: ORACLE not available" error
• "Oracle not available" error
• Can't log in to database from SQL*Plus
• Error with tnsping
• ORA-01034 and ORA-27101 on trying to log in to database
• Receiving "Oracle is not available" error after restart
• Receiving ORA-01034 error while connecting
• Suddenly getting ORA-01034 and ORA-27101
• Unable to connect to server with Oracle8i

• Why won't the mount and open happen automatically?

  ORA-01039: insufficient privilege on underlying objects of the view
  Solutions:
  

• Insufficient privileges error ORA-01039

  ORA-01053: user storage address cannot be read
  Solutions:
  

• ORA-1053 error after 8i installation on Windows 2003

  ORA-01078: failure in processing system parameters
  Solutions:
  

• Help with error ORA-01078
• ORA-01081: cannot start already-running ORACLE - shut it down first
  Solutions:
  

• Problems starting one of two databases on same server

  ORA-01089: immediate shutdown in progress - no operations are permitted
  Solutions:
  

• When opening database
• Cause of ORA-1089 error
• Error when stopping/starting Oracle SID
• ORA-01092: Oracle instance terminated. Disconnection forced
  Solutions:
  
• Database Configuration Assistant not executing
• Oracle installed, but error when creating db
• ORA-01092 error during 9i installation
• ORA-01092 error while executing database creation command

• ORA-01092 on creating a new database

  ORA-01110: data file string: 'string'
  Solutions:
  

• Database stopped, showing multiple error messages
• Input/output errors
• ORA-01110 error when not in archive log mode
• ORA-01113 and ORA-01110 errors on restarting database

• Too many open files error message

  ORA-01113: file n needs media recovery
  Solutions:
  

• ORA-01113 and ORA-01110 errors on restarting database

  ORA-01115: IO error reading block from file string (block # string)
  Solutions:
  

• Database stopped, showing multiple error messages
• User datafile needs media recovery
• Input/output errors

• Too many open files error message

  ORA-01122: database file string failed verification check
  Solutions:
  

• Database crash during hot backup

• ORA-1122 error and huge TEMP tablespace

  ORA-01157: cannot identify/lock data file string - see DBWR trace file
  Solutions:
  

• ORA-01033 error when taking backup

  ORA-01158: database %s already mounted
  Solutions:
  

• Cloning a production database into a development server

  ORA-01403: no data found
  Solutions:
  

• Errors during import of a dump file

  ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
  Solutions:
  

• ORA-1452 error after export/import

  ORA-01501: CREATE DATABASE failed
  Solutions:
  

• Avoiding Oracle errors
• ORA-01503: CREATE CONTROLFILE failed
  Solutions:
  

• Cloning a production database into a development server

  ORA-01535: rollback segment 'name' already exists
  Solutions:
  

• Errors when importing from same version
• ORA-01543: tablespace 'TEMP' already exists
  Solutions:
  
• Errors when importing from same version
• ORA-01555: snapshot too old: rollback segment number string with name "string" too small
  Solutions:
  
• Help with ORA-01555: snapshot too old
• Help with ORA-01555 during export
• Exporting a table that is constantly updated
• RBS monitor to catch ORA-01555 errors
• Can't escape ORA-01555 error!
• Cause of "snapshot too old" error

• Errors and slowness during export

  ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)
  Solutions:
  

• Errors and slowness during export

  ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed
  Solutions:
  

• Errors and slowness during export

  ORA-01630: max # extents (string) reached in temp segment in tablespace string
  Solutions:
  

• Resolving the ORA-01630 error
• ORA-01650: unable to extend rollback segment string by string in tablespace string
  Solutions:
  

• Errors and slowness during export

  ORA-01652: unable to extend temp segment by string in tablespace string
  Solutions:
  

• Help with ORA-01652 error -- unable to extend temp segment
• Solving ORA-1652 error
• High IO program is throwing ORA-01652 errors
• ORA-01652: add or resize datafile?
• Resolving errors ORA-01652 and ORA-04031
• Errors during building of tables
• ORA-01652 error when running query to delete large amount of data

• Questions about ORA-1652 error

  ORA-01653: unable to extend table xxx by xxx
  Solutions:
  

• Action can't be handled

  ORA-01658: unable to create INITIAL extent for segment in tablespace string
  Solutions:
  

• Identifying locks to resolve ORA-01658 and ORA-00054 errors

  ORA-01756: quoted string not properly terminated
  Solutions:
  

• Error inserting data into customer table

• Error inserting single quote into string

  ORA-01758: table must be empty to add mandatory (NOT NULL) column
  Solutions:
  

• Adding a new NOT NULL field to an existing table
• ORA-01940: cannot drop a user that is currently connected
  Solutions:
  

• Deleting a user from a tablespace
  

   

  ---

    ORA-02000 - ORA-03999
  [ Return to Table of Contents ]
  

  ORA-02019: connection description for remote database not found
  Solutions:
  

• Why am I getting the ORA-02019 error?

  ORA-02035: illegal bundled operation combination
  Solutions:
  

• When does 02035 error occur?

  ORA-02085: database link string connects to string
  Solutions:
  

• Problem with dblink: ORA-02085
• Setting GLOBAL_NAMES to false to use dblink

• Error after creating DBLink

  ORA-02201: sequence not allowed here
  Solutions:
  

• Can triggers be applied to sequence objects?
• ORA-02266: unique/primary keys in table referenced by enabled foreign keys
  Solutions:
  
• Truncate tables using PL/SQL
• ORA-02449: unique/primary keys in table referenced by foreign keys
  Solutions:
  
• Error when dropping objects
• Find all the 'son' constraints
• ORA-03001: unimplemented feature
  Solutions:
• Solving ORA-03001
• ORA-03113: end-of-file on communication channel
  Solutions:
  
• Whenever the client is idle for five minutes
• When trying to start up
• ORA-03113 when running a query
• Error when creating a queue table
• Problem installing Oracle on Red Hat Linux
• Failure installing 9i Database Configuration Assistant Tool on Win2000
• Getting end of communication error when submitting a query
• Solving error ORA-03113
• Archive log files generating quickly
• ORA-03113 error when querying table
• ORA-03113 trying to rebuild indexes
• What is the ORA-03113 error?
• ORA-03114: not connected to ORACLE
  Solutions:
  
• During the initializing database step
• Resolving the ORA-03114 error
• ORA-03121: no interface driver connected
  Solutions:
  
• ORA-03121 while attaching database

• What is the solution of the ORA-03121 error?

  ORA-03232: unable to allocate an extent of x blocks from tablespace x
  Solutions:
  

• ORA-03232 error
  

   

  ---

    ORA-04000 - ORA-05999
  [ Return to Table of Contents ]
  

  ORA-04030: out of process memory
  Solutions:
  

• Help with ORA-04030 -- out of process memory
• RMAN process ran out of memory

• ORA-04030: Out of process memory

  ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
  Solutions:
  

• In the job queue process
• Recursive SQL error when using Web app
• Consistently getting ORA-04031 error
• Error during patch installation
• Need fixes for ORA-04031
• Help with ORA-4031 error
• Resolving errors ORA-01652 and ORA-04031
• Error when trying to reduce temp tablespace
• Resolving a 04031 error
• Resolving the ORA-04031 error

• Minimizing generation of archive logs

  ORA-04043: object string does not exist
  Solutions:
  

• Workaround for ORA-04043: Can't describe object using db_link
• ORA-04052: error occurred when looking up remote object name
  Solutions:
  
• Error creating database link
• ORA-04076: invalid NEW or OLD specification
  Solutions:
  

• How to solve ORA-04076 error?

  ORA-04091: table string.string is mutating, trigger/function may not see it
  Solutions:
  

• Selecting rows from the same table in the trigger
• Resolving ORA-04091
• Workaround for the ORA-04091 error when checking ranges
• Resolving an ORA-04091 error
• Timestamping all rows of some tables on insert and update
• Writing an ON INSERT trigger without encountering mutating table error
• ORA-04098: trigger 'SYSTEM.LOG_ERRORS_TRIG' is invalid and failed re-validation
  Solutions:
  
• Trigger error in SQL*Plus
• 
  

   

  ---

    ORA-06000 - ORA-07999
  [ Return to Table of Contents ]
  

  ORA-06401: NETCMN: invalid driver designator
  Solutions:
  

• When trying to connect from Dreamweaver
• When using SQL*Plus on host computer
• Password creation in Oracle Developer 6i
• Error using JDBC to query local database
• Error trying to insert record through database link
• Resovling the ORA-06401 error
• ORA-06508: PL/SQL: could not find program unit being called
  Solutions:
  
• Resolving the ORA-06508 error
• ORA-06512: Backtrace message as the stack is unwound by unhandled exceptions
  Solutions:
  
• What is ORA-06512?
• Errors during import of a dump file

• Problems with exp utility after migration

  ORA-06532: Subscript outside of limit
  Solutions:
  

• New user error
• Determining the reason for the error message
• ORA-06544: PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  Solutions:
  
• How to resolve ORA-06544
• ORA-06550: line string, column string:string
  Solutions:
  
• Error when calling stored procedure
• Help with ORA-06550 error
• Resolving error ORA-06550
• Cause of ORA-06550 error
• Error during export of database
• Error when executing procedures
• Receiving error at export command
• Receiving ORA-06550 error

• Ways to handle an error on an INSERT statement

  ORA-06553: PLS-string: string
  Solutions:
  

• Error calling stored procedure from Java
• Removing Services entries, fixing ORA-06553

• Problems with exporting database after modifying database characterset

  ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
  Solutions:
  

• Help with ORA-06554 regarding package DBMS_STANDARD
• ORA-07445: exception encountered: core dump [10]
  Solutions:
  
• SQL subquery errors
• 
  

   

  ---

    ORA-08000 - ORA-11999
  [ Return to Table of Contents ]
  

  ORA-10033: sort run information (SRD*/SRS*)
  Solutions:
  

• ORA-10033 error won't let me connect

  ORA-10902: disable seghdr conversion for ro operation
  Solutions:
  

• Cause of ORA-10902 error
  

   

  ---

    ORA-12000 - ORA-13999
  [ Return to Table of Contents ]
  

  ORA-12154: TNS-12154: TNS:could not resolve service name
  Solutions:
  

• No connection to run Forms
• Copying tables from one DB to another via database link
• Configuring the TNSNAMES.ORA file

• Connecting to 10g database after rebooting server

  ORA-12203: TNS-12203: TNS:unable to connect to destination
  Solutions:
  

• On home computer
• After installing 7.3
• Unable to install Developer 2000
• Unable to connect to destination
• Resolving the PDE-POCO11 ORA-12203 error
• Problem connecting to a remote database
• Database crash during hot backup

• Problems connecting to database after installing Forms

  ORA-12502: TNS-12502: TNS:listener received no CONNECT_DATA from client
  Solutions:
  

• Resolving the TNS-12502 error
• ORA-12505: TNS-12505: TNS:listener could not resolve SID given in connect descriptor
  Solutions:
  
• Resolving the ORA-12505 TNS error
• ORA-12514: TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
  Solutions:
  
• When trying to create db link
• Error connecting through SQL*Plus
• Resolving the ORA-12514 TNS listener error
• Resolving the ORA-12514
• Accessing an Oracle instance with SQL*Plus
• ORA-12514 error when connecting through SQL*Plus
• Problems accessing 10g through SQL*Plus and Enterprise Manager

• Problems connecting after installation of 10g

  ORA-12528: TNS:listener: all appropriate instances are blocking new connections
  Solutions:
  

• ORA-12528 after shutting down and restarting instance

  ORA-12531: TNS-12531: TNS:cannot allocate memory
  Solutions:
  

• No new connections allowed

  ORA-12533: TNS-12533: TNS:illegal ADDRESS parameters
  Solutions:
  

• ORA-12533 during installation
• ORA-12535: TNS-12535: TNS:operation timed out
  Solutions:
  
• Timed out error and slow computer performance
• Error since converting to 9.2
• Getting ORA-12535 since upgrade
• "TNS: Operation timed out" error
• Error in ODBC connections

• TNS-12535 error connecting to remote machine

  ORA-12537: TNS connection closed
  Solutions:
  

• "TNS:connection closed" error

• ORA-12537 error when trying to connect

  ORA-12541: TNS: no listener
  Solutions:
  

• Causes
• Connecting to database through forms builder
• No listener error when logging in to Oracle8
• No listener error after install on XP
• Receiving ORA-12541 error trying to connect through Forms/Reports
• ORA-12542: TNS: address already in use
  Solutions:
  
• Error affecting nightly batch jobs
• ORA-12545: TNS-12545: Connect failed because target host or object does not exist
  Solutions:
  
• Error accessing 9i on Linux
• Error in Oracle connection
• Resolving error ORA-12545
• Resolving error ORA-12545
• Error message ORA-12545 during remote connect
• ORA-12545 error trying to open forms in Oracle 8i on Windows 2000

• ORA-12545 error when connecting to database via client

  ORA-12546: TNS: permission denied
  Solutions:
  

• DBA cannot connect to database
• Help with listener error
• ORA-12560: TNS-12560: TNS:protocol adapter error
  Solutions:
  
• When connecting to Oracle 9.0.2 on Win2K
• When logging in to svrmgr after install
• When connecting over dial-up
• When installing 8.1.7 on Windows 2000
• When creating new database
• When running exp
• Trouble connecting to listener after install
• Error running a form in a browser
• Connection problem with Forms/Reports
• Resolving ORA-12560 error
• Uninstalling Oracle9i
• "TNS:Could not resolve Service name" error
• Oracle 9i login error
• Receiving "TNSListener protocol adapter error" during installation
• Unable to connect to 9i on Windows 98

• Unable to log in after installing Oracle Client 9i

  ORA-12571: TNS-12571: TNS:packet writer failure
  Solutions:
  

• Resolving the "ORA-12571: TNS:Packet writer failure" error

• ORA-12571 error with Oracle 8i on Windows XP

  ORA-12638: Credential retrieval failed
  Solutions:
  

• Another Oracle server from a different LAN
• "TNS: Operation timed out" error
• ORA-12638 and ORA-01031 on Windows cluster

• Problems with Oracle applications after upgrading to XP

  ORA-12640: TNS-12640: Authentication adapter initialization failed
  Solutions:
  

• Backup batch jobs not running
• Error creating database link
• Database link works for a few days, then ORA-12640
• ORA-12663: TNS-12663: Services required by client not available on the server
  Solutions:
  
• Error using DESC across dblink
• ORA-12801: error signaled in parallel query server string
  Solutions:
  

• Errors during building of tables
  

   

  ---

    ORA-14000 - ORA-23999
  [ Return to Table of Contents ]
  

  ORA-1650: unable to extend rollback segment R05 by 512 in tablespace RBS Failure to extend rollback segment 6 because of 1650 condition.
  Solutions:
  

• Solving the ORA-1650 error message
• 
  

   

  ---

    ORA-24000 - ORA-25999
  [ Return to Table of Contents ]
  

  ORA-24008: queue table string.string must be dropped first
  Solutions:
  

• How to drop the example schemas from Oracle9i
• ORA-24801: illegal parameter value in OCI lob function
  Solutions:
  

• Export/import on table with clob datatype column

  ORA-25143: default storage clause is not compatible with allocation policy
  Solutions:
  

• Error inserting new record in table
• ORA-25150: ALTERING of extent parameters not permitted
  Solutions:
  
• Error inserting new record in table
• 
  

   

  ---

    ORA-26000 - ORA-27999
  [ Return to Table of Contents ]
  

  ORA-27038: skgfrcre: file exists
  Solutions:
  

• Avoiding ORA-27038 when creating a tablespace in 8i
• Avoiding Oracle errors
• ORA-27041: unable to open file
  Solutions:
  
• Errors causing Oracle instance to shut down

• Too many open files error message

  ORA-27072: skgfdisp: I/O error
  Solutions:
  

• Database stopped, showing multiple error messages

• Input/output errors

  ORA-27091: skgfqio: unable to queue I/O
  Solutions:
  

• Getting Oracle errors -- database and Web site are down
• Errors causing Oracle instance to shut down

• Input/output errors

  ORA-27101: shared memory realm does not exist
  Solutions:
  

• When trying to connect to the database
• Errors during reboot
• Unable to login after installation
• Trouble getting two database instances running
• Error when starting Oracle
• "Oracle not available" error
• Can't log in to database from SQL*Plus
• ORA-01034 and ORA-27101 on trying to log in to database
• ORA-27101 error after moving DB to new domain
• Suddenly getting ORA-01034 and ORA-27101

• Why won't the mount and open happen automatically?

  ORA-27123: unable to attach to shared memory segment
  Solutions:
  

• Error accessing database after migration to 9.2.0.3
• Error after upgrading to 9i Data Server patch set
• ORA-27123 while trying to create database after Red Hat Linux installation
• ORA-27125: unable to create shared memory segment
  Solutions:
  
• When creating Oracle database on Fedora Core 2
• 
  

   

  ---

    ORA-28000 - ORA-30100
  [ Return to Table of Contents ]
  

  ORA-28030: Server encountered problems accessing LDAP directory service
  Solutions:
  

• Using dblink to access a different server

  ORA-28547: connection to server failed, probable Net8 admin error
  Solutions:
  

• ORA-28547 trying to set up practice database

  ORA-29516: Aurora assertion failure: string
  Solutions:
  

• Hit an error
• "Aurora assertion failure" error
• ORA-30036: unable to extend segment by string in undo tablespace 'string'
  Solutions:
  
• Error loading data into target

• ORA-30036 error when executing update query
  

   

  ---

    Other error messages
  [ Return to Table of Contents ]
  

  SQL*Plus error messages

  SP2-0678: Column or attribute type can not be displayed by SQL*Plus
  Solutions:
  

• What is error SP2-0678?

  Import error messages

  IMP-00009: abnormal end of export file Solutions:
  

• Dump file error
• Error during import from 9i to 10g

• Errors during import of dump file

  IMP-00010: not a valid export file, header failed verification
  Solutions:
  

• Create tablespace to resolve IMP-00010 error?

  IMP-00015: following statement failed because the object already exists
  Solutions:
  

• Which IMP messages are warnings and which are errors?

  IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
  Solutions:
  

• Which IMP messages are warnings and which are errors?

  IMP-00028: partial import of previous table rolled back
  Solutions:
  

• Dump file error
• Error during import from 9i to 10g

• Errors during import of dump file

  Export error messages

  EXP-00002: error in writing to export file
  Solutions:
  

• Errors with character set in export

  ORADIM command syntax errors

  DIM-00019: Create Service Error
  Solutions:
  

• "Create service" error when starting DBCA
  

   

  ---

    For more information
  [ Return to Table of Contents ]
  

  Can't find a solution to the error that's got you stumped? Ask the experts for help and we'll add the answer to this list.

  You can also browse our other learning guides on the following topics:

• Backup and recovery
• Becoming an Oracle Certified Professional
• Oracle security
• Performance tuning
• PL/SQL
• RDBMS fundamentals

• SQL