About Lepa Job title Lead Application Developer Poll How Is Site Load Performance?: Pages Load Fast Pages Load Somewhat Fast Pages Load Somewhat Slow Pages Load Slow Pages Load Very Slow Regards Taj Report message to a moderator Re: dba_views [message #240123 is a reply to message #240089] Thu, 24 May 2007 03:30 moiznaz Messages: 4Registered: May 2007 Location: SP2-0333 Illegal spool file name: spool_name (bad character: 'character_name') Cause: An invalid filename was entered in the SPOOL command. Action: Allocate more memory by closing some applications. his comment is here
Action: Specify a valid option. SP2-0027 Input is too long (> max_characters characters) - line ignored Cause: The input value specified was too long. Action: Refer to the Oracle Database Error Messages for the specified ORA error message. SP2-0806 Function created with compilation warnings Cause: The PL/SQL function has been created, but has one or more warnings, informational messages or performance messages that may help you to improve your check over here
Action: Replace the invalid or incomplete string in the database with a valid or complete string. Action: Check the syntax of the STORE command for the correct options. SP2-0110 Cannot create save file file_name Cause: An attempt was made to save the content of the SQL buffer to a file and the file could not be written.
Action: Check memory usage. users last 24h23Act. Action: Free up additional memory by: closing applications not required; reducing the size of the command, or statement; or by recoding the query to select fewer records. Developers can ask questions, help answer questions, or just browse code and articles contributed by users.
Action: Use the SQL*Plus SHOW ERR[ORS] command to display the warnings and messages. The time now is 08:11 AM. The most common cause is that ORACLE_HOME has not been set. http://www.error-code.org.uk/view.asp?e=ORACLE-SP2-0749 Check the statement for a typing mistake in the directory name.
Action: Specify a username and a connection identifier in the FROM clause. SP2-0501 Error in SELECT statement: Oracle_database_error_message Cause: Invalid SELECT statement found in the COPY command. Please don't use IMSPEAK 4. Action: Free up additional memory by: closing applications not required; reducing the size of the command, or statement; or by recoding the query to select fewer records.
Action: Enter a valid date or a date in the required format. http://www.orafaq.com/forum/t/82309/ SP2-0590 A COMPUTE function must appear before each LABEL keyword Cause: The function COMPUTE must appear before each LABEL keyword. Action: Check the syntax of the SQL*Plus executable for the correct options. SP2-0026 No lines to delete Cause: There was nothing in the SQL buffer when using the DEL command.
Make sure that the file has the privileges necessary for access. this content This message is hard coded (in English) in the SQL*Plus source code so it can be displayed on message file error. Action: Make sure that the buffer variable name is correct and try again. Action: Reduce the length in the substitution variable and try again.
SP2-0832 Package altered with compilation errors Cause: The PL/SQL package has been altered, but has one or more error messages. Action: Check the syntax of the DESCRIBE command for the correct usage. SP2-0263 no room to allocate COMPUTE block for column_name ON page/report/column_name Cause: Insufficient memory allocated to the COMPUTE block. weblink Action: Re-enter the starting line number with a smaller line number.
This entry in the message file is for documentation purposes only. Action: Check that the database limit on number of active sessions has not been exceeded. Same might happen to MAI3660Budgets form.
Action: Free up additional memory by: closing applications not required; reducing the size of the command, or statement; or by recoding the query to select fewer records. SP2-0426 Input truncated to number_of_characters characters Cause: There was no carriage return at the last line of the SQL statement. SQL> Then I created a public synonym for that table: SQL> create public synonym andrew for andrew 2 / Synonym created. Action: Free up additional memory by: closing applications not required; reducing the size of the command, or statement; or by recoding the query to select fewer records.
Use the sqlplus/admin/help/hlpbld.sql script to install HELP on this database: sqlplus system @hlpbld.sql helpus.sql SP2-0172 No HELP matching this topic was found. Action: Connect to a database and re-try the operation. Action: Check the platform specific environment to verify that you are connecting to an Oracle server that is at least release 9.2. SP2-0840 Type altered with compilation errors Cause: The PL/SQL type has been altered, but has one or more error messages.
SP2-0666 WARNING: SHIFTINOUT only affects shift sensitive character sets Cause: The NLS character set used in this session does not contain shift sensitive characters. What is the command you are using to create a SYNONYM for that table? SP2-0017 missing column name after keyword_name keyword Cause: There was no column name after the specified keyword. SP2-0540 File file_name already exists.
Action: Check the syntax of the CHANGE command for the correct options. Action: Use the SQL*Plus SHOW ERR[ORS] command to display the warnings and messages. Action: Check the syntax of the COPY command for the correct options. Action: Check that the line number is correct and try again.
SP2-0613 Unable to verify PLAN_TABLE format or existence Error enabling autotrace_report report Cause: An AUTOTRACE command was issued by a user with insufficient privileges, or who did not have a PLAN_TABLE. The SET SHIFTINOUT command is unnecessary. Action: No action required.