Sunday, May 18, 2008

Solving 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
Oracle9i Database Error Messages
Release 2 (9.2)
Part Number A96525-01

http://download-west.oracle.com/docs/cd/B10501_01/
server.920/a96525/toc.htm




  • 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-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

    SOURCE : http://searchoracle.techtarget.com/news/article/0,289142,sid41_gci933283,00.html?mo=1&Offer=PRbur0506fg

    • Posted by at
    Labels:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)