Oracle 11g Error Codes and Solution Suggestions from ORA-19700 to ORA-19900 ORA-19700: device type exceeds maximum length of string Cause: The device type indicated is invalid. Action: Supply a correct device type and retry the allocation. ORA-19701: device name exceeds maximum length of string Cause: The device name indicated is invalid. Action: Supply a correct device name and retry the allocation….
Category: Databases
Oracle 11g Error Codes and Solution Suggestions from ORA-19600 to ORA-19700
Oracle 11g Error Codes and Solution Suggestions from ORA-19600 to ORA-19700 ORA-19600: input file is string string (string) Cause: This message identifies the input file for a failed copy operation. Both the file number and name (if the name has been determined) are shown. For a datafile, the file number refers to the datafile’s absolute file number as shown…
Oracle 11g Error Codes and Solution Suggestions from ORA-19500 to ORA-19600
Oracle 11g Error Codes and Solution Suggestions from ORA-19500 to ORA-19600 ORA-19500: device block size string is invalid Cause: the device block size returned by sequential I/O OSD is invalid Action: If the block size was set by using the PARMS option of the Recovery Manager ALLOCATE CHANNEL command, then the specified block size must be changed. If no…
Add Time Zone Offset To Timestamp in Oracle
If you have to add or remove offset to timezone, you can use below sql syntax. I will use for Istanbul timezone. Database stamp timezone as UTC and not add Istanbul timezone offset when insert operation. If you have to show on reports as Istanbul time zone, you can use below SQL. SQL> select to_char(…
Oracle 11g Error Codes and Solution Suggestions from ORA-19200 to ORA-19400
Oracle 11g Error Codes and Solution Suggestions from ORA-19200 to ORA-19400 ORA-19200: Invalid column specification Cause: All input arguments must be valid columns Action: Specify a valid list of columns ORA-19201: Datatype not supported Cause: The particular datatype is not supported in the XMLGEN operator Action: Specify only supported datatypes as arguments to the XMLGEN operator ORA-19202: Error occurred…
Oracle 11g Error Codes and Solution Suggestions from ORA-19000 to ORA-19200
Oracle 11g Error Codes and Solution Suggestions from ORA-19000 to ORA-19200 ORA-19000: missing RELATIONAL keyword Cause: The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification. Action: Supply the RELATIONAL keyword in the storage clause ORA-19001: Invalid storage option specified Cause: An invalid storage option was specified for the XMLType. Action: Supply a…
Oracle 11g Error Codes and Solution Suggestions from ORA-18000 to ORA-18200
Oracle 11g Error Codes and Solution Suggestions from ORA-18000 to ORA-18200 ORA-18000: invalid outline name Cause: The parser detected a missing or invalid outline name Action: None ORA-18001: no options specified for ALTER OUTLINE Cause: The parser detected that no clause was specified on the command Our performance tests, which are not typical as they exercise all branches…
Oracle 11g Error Codes and Solution Suggestions from ORA-17500 to ORA-17635
Oracle 11g Error Codes and Solution Suggestions from ORA-17500 to ORA-17635 ORA-17500: ODM err:string Cause: An error returned by ODM library Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance ORA-17501: logical block size string is invalid Cause: logical block size for oracle files must be a multiple of the physical block…
Oracle 11g Error Codes and Solution Suggestions from ORA-16800 to ORA-17000
Oracle 11g Error Codes and Solution Suggestions from ORA-16800 to ORA-17000 ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE Cause: The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination. Action: Reenable the standby database or the entire configuration to…
Oracle 11g Error Codes and Solution Suggestions from ORA-16700 to ORA-16800
Oracle 11g Error Codes and Solution Suggestions from ORA-16700 to ORA-16800 ORA-16700: the standby database has diverged from the primary database Cause: The primary database may have been flashed back or restored from a backup set and then reopened with the RESETLOGS option. Action: Re-create the standby database from the primary database or flash back the standby…