Oracle SP2-0158: unknown SET option "message"

I have a sql file apend.sql that containg it first line as:SET MESSAGE OFFThis file was running fine with SQL*PLUS 8.1 (Oracle 8i)But after migration to Oracle10g and it is running with SQL*Plus 10.2the following message is coming:SP2-0158: unknown SET option "message"Can anyone give the resaon for ...

Oracle Error sp2-0158

I have written this slqplus script define fileList=&1   TTITLE SKIP 1 LEFT 'Variazione nel flusso Kler''s TIP' SKIP 2   SET NEWPAGE 1 SET SPACE 0 SET LINESIZE 5000 SET PAGESIZE 20 SET FEEDBACK OFF SET COLSEP '|' SET UNDERLINE OFF SET HEADING ON   SPOOL &fileList     ...

Oracle Error sp2-0158

I have written this slqplus script define fileList=&1   TTITLE SKIP 1 LEFT 'Variazione nel flusso Kler''s TIP' SKIP 2   SET NEWPAGE 1 SET SPACE 0 SET LINESIZE 5000 SET PAGESIZE 20 SET FEEDBACK OFF SET COLSEP '|' SET UNDERLINE OFF SET HEADING ON   SPOOL &fileList     ...

SP2-0734: unknown command beginning "tkprof..."

When I'm trying to run tkprof I get the next error:SQL> tkprof ora_36172.trc ora36172.prf sys=noSP2-0734: unknown command beginning "tkprof ora..." - rest of line ignored.I tryed to run it from command line - but got the same error.How do I get this to work?Any help is highly appreciate ...

Oracle SP2-0042: unknown command "UNION" - rest of line ignored.

I used sql script for creating DB structure on Oracle 8 with no errors.I got "SP2-0042: unknown command "UNION" - rest of line ignored" error on Oracle 9i.Do you anybody tell me whats wrong ? ...

Oracle Strange SP2-0042: unknown command in sqlplus

everyone,i was attemptting to execute a sql statement from an external file. But i got "SP2-0042: unknown command "ï»? - rest of line ignored.". It's works with ANSI but can not based on UTF8 encoding.My file only contains as following : spo db_changesfff.logSPO OFF Anyone has ideas? ...

Oracle "SP2-0734: unknown command..." error while importing a dump file

i want to import a dump file into my database named orcl, and i come accross the same error after executing the import command. my import command is:*************************SQL> imp mvdemo/mvdemo file=mvdemo.dmp full=y ignore=y*************************i use oracle 10g enterprise edition.i create ...

Ubuntu unknown boot option

I am trying to install Ubuntu 8.1 using Microsoft Virtual PC, but I got this error: unknown boot option.Is there any previous step that needs to be done before installing?P.S. I have no problem with version 7.10 ...

Oracle SP2-0734: unknown command beginning

I have just installed 8i on a WinXP. And I have this problem :SQL> dbms_output.put_line('mystring');SP2-0734: unknown command beginning Do you know the reason and the solution please ?Many ...

Oracle sql or pl/sql for olap

How can I (successfully) run a script to define OLAP metadata?For example: After running a wizard to create an OLAP dimensionI saved the generated script. But if I try to runit on SQLPlus it fails.The script (that works inside the wizard) is:CREATE DIMENSION MM.REPRESENTADA_DIM LEVEL REPRESENTADA IS ...

Oracle plz evaluate this query

this is one of the questions in 1z0-001 exam Examine the code:SET SERVER OUTPUT ONDECLAREv_char_val varchar2(100);BEGINv_char_val:= ‘Hello World’,DBMS_OUTPUT.PUT_LINE(v_char_val);ENDSET SERVER OUTPUT OFFThis code is stored in a script file name “myproc,sql”. Which statement executes thecode in t ...

Oracle Problem with: col "414 Object P&ID Ref2" format a20

I want to set the column '414 Object P&ID Ref2' to the format of a20, however I get the following error because of th '&':col "414 Object P&ID Ref2" format a20 Enter value for id: col "413 Object P&ID Ref1" format a20 SP2-0158: unknown COLUMN option "413"How can I solve this without ...

Oracle Problem in enabling autotrace

I am trying to enable autotrace on using the following command.set autotrace trace only in sql prompt and i am getting the following error.SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportSP2-0158: unknown SET option "only"Please ...

Oracle Anything wrong when using DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE

I am using 'chang data capture' in 9i db. I copy and past and custermize DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE like below.EXECUTE DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE (OWNER => 'cdc',\ CHANGE_TABLE_NAME => 'CLAIM_ct', \CHANGE_SET_NAME => 'SYNC_SET', \SOURCE_SCHEMA => 'RDRDBA ...

Oracle set aoutotrace

i'm about to practice with tunings & performance i've try to do from the sqlplus :set aoutotrace traceonly SP2-0158: unknown SET option "aoutotrace" can someone please tell me what is the problem .my d.b version is 10g Release 10.2.0.1.0 ...

Oracle SP2-0734 unknown command beginning exp - Export Error

I thought this may be because catexp.sql has not been run on this Oracle 9i database, however the role EXP_FULL_DATABASE exists.Shall i try re-running catexp.sql However, i only have the system password and i think i have to run it as 'sys' (can i run it as system ?)-is there a role that system will ...

Oracle SP2-0042: unknown command " ■c" - rest of line ignored.

On a 64bit install of oracle, i'm trying to run a script within sqlplus such as @c:/create.sqlhowever when i run that, somehow it seems the @ sign as a ■ and screws up my script execution. Has anyone seen this before? ...

Oracle Error with ENTMAP option

I am using Oracle9i rel 2 and have script file as below: (which is similar to the examples shown on http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/win.901/a88826/ch46.htm#1008045)SET VERIFY OFFSET PAGESIZE 200SET MARKUP HTML ON ENTMAP OFFPROMPT Current Session Listing PROMPT TESTSE ...

Oracle ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

Haii try to use dbms_stats to give me a report ofwhat statistics is missing, While it is running ,i got below errorAny idea ,should be appreciatedRegardsmohan SQL> declare2 a dbms_stats.objecttab;3 begin4 dbms_stats.gather_database_stats5 (OPTIONS=>'LIST EMPTY',OBJLIST=>a);6 7 for i in 1 .. ...

Oracle HTML DB1.6 installation --Kjell Ove, please reply :-)

After installed the Oracle 10g db, I tried two ways to install html db:1. in the oracle 10g bin directory, I click the sqlplus icon, then a dos terminal show up:(I enter the following info, and get the errors) Enter user-name: sysdba Enter password:sysdbaERROR:ORA-01017: invalid username/password; l ...

Oracle SQL * PLUS Error

Getting this Error Message:SQL> set severoutput onSP2-0735: unknown SET option beginning "severoutpu..."SQL> set severoutput off;SP2-0735: unknown SET option beginning "severoutpu..."Please Help Resolving this. ...

Oracle Unable to Schedule a Job Due to Connection to host failed:Conn. refused

I'm using 10g 10.2.0.1.0 on a Windows server.Within Database Control, I'm trying to schedule a job - this is the error I get:"Validation Error Examine and correct the following errors, then retry the operation:Error - Connection to host as user CORPORATE\jbates failed: IOException in sending Request ...

Oracle How to spool a HTML report

could you show me how I can set sqlplus in order to get a html report?For example I've tried to writeset pagesize 1000set scan offset markup html on spool on head ' - ' COLUMN field_1 HEADING "Field number one" COLUMN field_2 HEADING "Field number two" SPOOL c:\temp\report.htmlSELECT field_1, field_ ...

Oracle data pump utility

Hai everybodyi am using oracle 10g 10.2.0.1.0. i wanted to use the data pump commands like expdp and impdp.When i tried ' expdp' the system displayedSP2-0042: unknown command "expdp" - rest of line ignored.then after searching in the net i have created a directory 'my_dump_dir' in oracle directory a ...

Oracle Cannot set unqname

I am trying to install Oracle 11gR2 for the first time on a test server (I am not a DBA).I have got a message saying that the installation was successful but that I had to set the Oracle_UNQNAME to database unique name in order to be able to start the database control.I have looked at many posts and ...

Oracle ORA-00922: missing or invalid option

I am using oracle 10g datbase.and trying to create a list of tables of 300 tables - a sampel is given belowCREATE TABLE "SCHM1"."HOLIDAYS"( "DATE" DATE NOT NULL ENABLE,"DESCR" VARCHAR2(40),"EXTRA_HOURS" NUMBER(2,0),"HOLIDAY_GROUP" VARCHAR2(5) NOT NULL ENABLE,"CREATED_BY" VARCHAR2(12),"CREATED_ON" DA ...

jQuery r2722 - added support for icons. "icons" option allows for a hash of selector/iconClass propertie...

Author: scottjehlDate: Fri Jun 12 08:54:57 2009New Revision: 2722Modified:branches/labs/selectmenu/index.htmlbranches/labs/selectmenu/ui.selectmenu.cssbranches/labs/selectmenu/ui.selectmenu.jsLog:added support for icons. "icons" option allows for a hash of selector/iconClass properties, to ...

Sp2- 0734

SP2-0734: unknown command beginning "DR0P INDEX..." - rest of line ignored.How to resolve this error..and what is the cause. ...

Sp2-0027

I have a sql quiery (with joins and all) which has 25000 characters. I am unable to paste it all in sqlplus (may b because sqlplus doesnt allow more than 'some' characters).I saved the sqlquery as .sql and when i ran, got the following error:SQL> @oracle.sql; Input truncated to 7499 characters SP ...

Oracle SP2-0042 when copy paste the *

Did you notice this annoying enhancement in 10g : you cannot copy-paste the listing of the current line because of the star marking the current line.SQL> l 1 select 2 * 3 from 4* dual if you want to copy-paste the code above in your sqlplus session, it was working in 7,8,9. But no longer in 10!SQ ...

Oracle SP2-0734 while creating database

i have a initdev.ora file as belowinitdev.ora db_name = DEVdb_block_size = 8192db_files = 200compatible = 9.2.0.1.0db_file_multiblock_read_count = 32db_block_buffers = 9600shared_pool_size =40000000SORT_AREA_size=4096000log_checkpoint_interval = 10000processes = 200dml_locks = 500log_buffer = 196608 ...

Ubuntu XFS and ACLs ; just always there? (no acl mount option)

This isn't a problem, just a curiosity:I've been playing around with ACLs on one of my partitions, formatted as XFS, now if I specify this in fstab:UUID=c805f435-26c2-4d63-84b6-57fc49e90c94 /storage xfs noatime,acl 0 2I can't mount it; (from dmesg)[ 220.200585] XFS: unknown mount option [acl]. Inter ...

Oracle SP2-0734 error..

While creating database manualy getting the following error.SQL> @C:\oracle\oradata\saravan\createdb.sqlSP2-0734: unknown command beginning "datafile '..." - rest of lineignored.SP2-0734: unknown command beginning "noarchivel..." - rest of lineignored.Database created.SQL>createdb.sql Sql file ...

Getting the TEXT value of an OPTION, NOT the value

...PHP expert, JavaScript Novice......long story short, I need to use some JavaScript to grab the -text value- (NOT the input value) of a selected option box on a page.What I have:<SCRIPT type="text/javascript">var selects = document.getElementsByTagName('option');for(i=0; i < sel ...

Oracle Unknown command "expdp"

I am the beginner in oracle, I just started to learn and followed with the guide from oracle. I received the error when I tried to type the following statement.expdp system/password schemas=hr directory=dmpdir dumpfile=schema.dmpsp2-0734: unknown command beginning "expdp syst..." - rest of line igno ...

Oracle SP2-0734

Why I'm getting this error only when I run it from the script i.e @"path..." INSERT INTO CI_ALG_TYPE_L ( ALG_TYPE_CD, LANGUAGE_CD, DESCR50, DESCRLONG, OWNER_FLG ) VALUES ('CM-DR-SVC ', 'ENG', 'Calculate deposit amt based on local requirements', 'This Deposit Recommendation Algorithm will calculate t ...

Oracle SQL Plus giving SP2-0024: Nothing to change error

I'm just about to lose my mind.I'm running the following in SQL Plus - set echo offset feedback offset linesize 1000set sqlprompt ''spool c:\TEMP2\App_Eng1.csv replaceSelect A.OBJECTOWNERID||','||B.OBJECTVALUE1 from PSPROJECTITEM B, PSAEAPPLDEFN AWhere B.PROJECTNAME = 'PRJ732075'and B.SOURCESTATUS = ...

Oracle how to trap SP2- errors? script fails but sqlplus returns success

i have the following scriptSET NEWPAGE NONE;SET SPACE 0;SET LINESIZE 32767;SET PAGESIZE 0;SET ECHO OFF;SET FEEDBACK OFF;SET VERIFY OFF;SET HEADING OFF;SET MARKUP HTML OFF;SET TERMOUT OFF;SET TRIMOUT ON;SET TRIMSPOOL ON;SET TAB OFF;SET LONG 4000;SET LONGCHUNKSIZE 4000;SET WRAP OFF;ALTER SESSION SET N ...

Oracle WITH clause: SP2-0734:

Hello. Got a problem with the WITH clause in SQL*Plus (sqlplus.exe), can't see why this happens.12:48:49 RAY@CNRTEST1> select * from v$version;Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64biPL/SQL Release 10.2.0.4.0 - ProductionCORE 10.2.0.4.0 ProductionTNS for Solaris: Version 1 ...

Oracle too much SP2-

Good morning all,When I running scripts, I got following message.second attempt is OKSP2 - 0310: unable to open file "WITH.sql"SP2 - 0734: unknown command beginning "MAXVALUE 9…" - rest of line ignore.SP2 - 0042: unknown command "MINVALUE 1" - rest of line ignore.CACHE 20SP2 - 0042: unknown comman ...

Oracle SP2, ORA-01400:

Good morning All,While loading data, I got following messages:SP2-0734: unknown command beginningORA-01400: cannot insert NULL intoWhat difference between SP2 and ORA?Any help? ...

Oracle Unknown command beginning "shutdown i

Can any one provide me solution. i unable to shutdown my dabase it showing below message when i make my database into downmode. SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 19 14:19:58 2008(c) Copyright 1999 Oracle Corporation. All rights reserved.Enter user-name: sys as sysdbaConnected to:Or ...

Oracle loadjava - unknown command error

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product.I am trying to excecute loadjava which results in the following error:SP2-0734: unknown command beginning "loadjava -..." - rest of line ignoredPossible explanations? ...

Oracle doubt in plsql

hai...i have a table like this...PROCEDURE SHOW_UNSTRUCTURED_EDITArgument Name Type In/Out Default? P_TEMPLATE_ID NUMBER IN DEFAULTP_TEMPLATE_NAME VARCHAR2 IN DEFAULT PROCEDURE SHOW_UNSTRUCTURED_PREVIEWArgument Name Type In/Out Default? P_TEMPLATE_ID NUMBER INP_TEMPLATE_NAME VARCHAR2 IN i tried like ...

Oracle Remote Database link assistance

I have been attempting to create a remote database connection accross a network. Thanks to some assitance given previously on the forum and using the link below i have had some success;http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/ds_conce.htm#15653I can now create a link t ...

Oracle tried expdp and facing issues please help

This is continuation with my previous thread on expdp - unable to run expdp. I tried different optionsoption 1: run from command prompt:output 1:C:\usrexp>expdp usr@qadb/usr DIRECTORY=USR_META_DATA_PUMP_DIR DUMPFILE=usr.dmp CONTENT=METADATA_ONLY'expdp' is not recognized as an internal or external ...

Oracle ERROR in 9i standby - ORA-01153

I am getting error while firing"recover standby database " command in my 9i standby.We are manually moving the archivelogs to standby from production, and firing the above command. All are done thru scheduled scripts .We have a recovery_run log file, with the detailed description of the recovery pro ...

Oracle Recovery problem

I need to recover the database, details are:Oracle 10g(relese 2) on RHEL 4.2The Scinario is:1. rman>backup database 2. SQL> alter system backup controlfile to trace3. SQL> ! rm /u01/oracle/app/oradata/orcl/control*4. SQL> ! rm /u01/oracle/app/oradata/orcl/redo02.lo (only two group there) ...

jQuery Migrations

all.I'm working on a project requiring client-side data storage based onthe new HTML 5 Offline applications spec. Having a database on theclient like Google Gears is a great idea, but it'd be nice to have aframework to manage the database.I was thinking of running up a jQuery plugin that doe ...

jQuery r2730 - added demo with custom icons

Author: scottjehlDate: Fri Jun 12 10:19:06 2009New Revision: 2730Added:branches/labs/selectmenu/sample_icons/branches/labs/selectmenu/sample_icons/24-podcast-square.png (contents, props changed)branches/labs/selectmenu/sample_icons/24-rss-square.png (contents, props changed)branches/labs/selectmenu/ ...