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-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 "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 ...

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 "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 unknown command beginning "recover da..." - rest of line ignored

I have one corrupted datafile (status column from v$datafile have value 'RECOVER' for it and I get ORA-01113, ORA-01110 when I try to get it online). It seems I need manually recover datafile via 'RECOVER DATAFILE' command. However when I issue it in SQL*Plus I get: 'unknown command beginning "recov ...

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

Sp2- 0734

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

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

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

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 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 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 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? ...

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 IMP command not found!! HELP

HELP! I am trying to import a dump file and any attempt to use the IMP command from the PL/SQL command line it tells me...SQL> imp XXXXXXXX/XXXXXXXX file=mcmisp.dmp log=imptomcqs.log fromuser=mcmis touser=mcmisSP2-0734: unknown command beginning "imp XXXXXXXX..." - rest of line ignored.Please tel ...

Oracle problem with command

the command is not working for meSQL> !oerr ora 00018SP2-0734: unknown command beginning "! oerr ora..." - rest of line ignored. ...

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 About DBMS_STATS command !!!!!

I dont know how the DBMS package query is run . When I m going run the following queryin SQL prompt , it shows the following error : SQL> set serveroutput onSQL> DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME=>'PERFSTAT',CASCADE=>TRUE;SP2-0734: unknown command beginning "DBMS_STATS..." - rest of ...

Oracle Create pfile command (10.2.0.1)

I have upgraded our database from 8.1.7.4 to 10.2.0.1 through DBUA.Upgradation completed successfully.I have already opened the database through SQL editor.But now, when i create pfile=' \path' from spfile=' \path' my sql prompt changes as below :- SQL*Plus: Release 8.1.7.0.0 - Production on Fri Mar ...

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 Need a basic command in sql pls...

I am beginner in sql, when i write the query like this "select * from tab;" this query brings all unwanted tables,i just want to see only my tables which i have created pls some one tell me.I showed below how it look likes. Thanking u all. SQL> selec * from tab;SP2-0734: unknown command beginning ...

Oracle9i forms developer-java objects scripts

I have installed Oracle9i developer suite on window 2000.Trying to follow up with postinstall tasks.Installation Guide says to run scripts to install java object support.The *sqls and *.plb scripts ran OK but while running "dedbjava.jar" I got following error msg.SQL> @d:\oracle\oracle9ids\dbs\de ...

Oracle New user !!!

Just created the newuser in 10g.I tried to login through sqlplus and got the following error-rwxr-x--x 1 oracle oinstall 830120 Aug 18 14:23 exp-rwxr-x--x 1 oracle oinstall 140128 Aug 18 14:23 tkprof-rwxr-x--x 1 oracle oinstall 898416 Aug 18 14:23 sqlldr-rwxr-x--x 1 oracle oinstall 12838968 Aug 18 1 ...

Arrays in Oracle SQL

When I try to create an array in Oracle 9i, it gives me an error. Here's what i did:SQL> type myarray is table of number index by binary_integer;and here's the error:SP2-0734: unknown command beginning "type myarr..." - rest of line ignored.Please teach me how to make arrays (without th ...

Oracle DBMS_JOB not recognised

Using Oracle8i and I'm running the following command:-dbms_job.submit(:j, 'USP_EXPIREBASKETS(SYSDATE);', SYSDATE, 'sysdate + (60/(24*60*60))');I get this error message back:-SP2-0734: unknown command beginning "dbms_job.s..." - rest of line ignored. What should I be checking? The dbms_job package is ...

oracle scripts fail need help

I cannot get my new scripts to run correctly:SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 29 13:57:32 2004(c) Copyright 2000 Oracle Corporation. All rights reserved.Connected.Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP and Orac ...

I can't purge recyclebin

I use Oracle 10g (Oracle Database 10g Enterprise Edition Release 10.1.0.3.0)and I log in as sys user, but I can't purge tablespace:this is the error:SQL> show userUSER Φ "SYS"SQL>SQL> select tablespace_name from dba_data_files;SYSTEMUNDOTBS1SYSAUXDATASQL> purge tablepsace ...

Cannot purge recyclebin

SQL*Plus: Release 9.0.1.4.0 - Production on Thu Feb 24 16:52:33 2005(c) Copyright 2001 Oracle Corporation. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> purge recyclebin;SP2-0734: unkn ...

Why Can't I Call This Procedure ?

Hi, I create and then try to call the procedure below, getting errors like : SP2-0734: unknown command beginning "InsertOrde..." - rest of line ignored.Can anyone explain what I am doing wrong here ?CREATE OR REPLACE PROCEDURE InsertOrder(Drinker IN VARCHAR, Pub IN VARCHAR, Drink IN VARCHA ...

New line in update with sqlplus file

I'm trying to load in a file where some of the fields have newlines. I want to keep these new lines in there, but I get the following error for my update statements:SQL> @540.sqlSP2-0734: unknown command beginning "import Sys..." - rest of line ignored.the statements are along the lines ...

create view

i am creating batch file for creating view the view is created on user1 schema and tables used for creating view is on user2 schema.iam getiing errorSP2-0734: unknown command beginning "from LIFEC..." - rest of line ignored.SP2-0734: unknown command beginning "where cln..." - res ...

Problem in inserting String into clob field

I have a long .log file where i need to inert into the CLOB field of oracle table.I am inserting the log file after i convert it into string.But i am getting the following error.ERROR:ORA-01756: quoted string not properly terminatedSP2-0734: unknown command beginning "+ ReturnSt..." - rest ...

How to insert String into CLOB field

I have a long .log file sitting in the unix file server.I convert the file into the string and insert into the clob filed in oracle database. but i am getting the following error.ERROR:ORA-01756: quoted string not properly terminatedSP2-0734: unknown command beginning "+ ReturnSt..." - res ...

Oracle Error creating view with CASE -- WHEN statement in SQL*Plus

I am using Oracle 8i 8.1.7I have an Oracle view which uses CASE...WHEN statements.The view compiles fine in DBA studio.Using TOAD I saved the view as an *.sql file.However, when I try to create the view in SQL*Plus I get the following error:SP2-0734: unknown command beginning "CASE WHEN ..." - rest ...

Oracle how to run initjvm.sql?

am have Window 2000 machine. AM trying to run initjvm.sql from the sqlplus prompt, but am not able to.SQL> orahome81\javavm\install\initjvm.sqlSP2-0734: unknown command beginning "orahome81\..." - rest of line ignored.am connected as sys/change_on_install as sysdba.am not sure how to run that scr ...

Oracle Job Details

I am trying to schedule a job on our test Database . I want to see whether the job is scheduled properly or not. Also i wantto test itCan you please tell me the statements i should use to do the following 1. View the job status2. Alter the job3. force the job to run4. Force the job to run nowI tried ...

Oracle Hi Pls help me understand this problem

I know its a weired doubt, i select (select empno,ename,sal,deptno from emp where ename = 'SMITH')Result what i have is EMPNO ENAME SAL DEPTNO ------------ ------------- 7369 SMITH 800 20 I copied the result from the sql*plus and pasted the same into the same tool, SQL> EMPNO ENAME SAL DEPTNOSP2- ...

Oracle external table syntax

trying to use SQL to create/declare an external table which is a comma delimited ascii file, to have its records imported into my permanent table. my syntax:CREATE DIRECTORY xfer_files AS 'v:\text_files\';GRANT READ ON DIRECTORY xfer_files TO public;GRANT WRITE ON DIRECTORY xfer_files TO public; CRE ...

Oracle Is VARRAY supported when defining tables?

A bit long-winded, but logically related comments and questions....1) I registered an XSD with this statement: BEGIN DBMS_XMLSCHEMA.registerSchema(SCHEMAURL =>'http://localhost:8080/home/SCOTT/poSource/xsd/purchaseOrder.xsd',SCHEMADOC => bfilename('XMLDIR3', 'purchaseOrder.xsd'),LOCAL => FA ...

Oracle Self documenting program in SQL

Did anybody write a query that duplicates itself as an output in SQL yet? In the list of languages athttp://www.nyx.net/~gthompso/quine.htmSQL is absent. Excluding cheats like the one below in SQL*Plus:SQL> SP2-0734: unknown command beginning "SP2-0734: ..." - rest of line ignored.SP2-0734: unkno ...

Oracle Where do I find DBMS_STATS procedures?

I am just beginning the preinstall section for the Oracle 9.2.0.6 patch set and they indicate that I should run the following procedures (scripts?)":SQL> DBMS_STATS.DELETE_SCHEMA_STATS('SYS');SQL> DBMS_STATS.GATHER_SCHEMA_STATS('SYS');This is to clear out stats before the upgrade so that I won ...

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 import demo file failed

i'been reading MapViewer users guide and for the purpose of demo i should import the demo 'mvdemo.dmp' file into 10g db under the supplied user 'scott'. pdf (1.7 getting started using MapVierwer, pgs: 1-28, 1-29) says i should use the following command:imp SCOTT/TIGER FILE=mvdemo.dmp FULL=Yi started ...

Oracle Import Spatial Data

I want to import a database which contains spatial datas.The file that i want to import is called mvdemo.dmpFirst of all i opened SQL plus and i created a database user for the import. I wrote the following command :grant connect,resource to mvdemo identified by mvdemo.Until here, i have no problems ...

Oracle Shell script..

Guys,I am having the text wrapped when i submit it from the shell script.. The coding is below runsql_analyze_db() {statement=$1echoLog "$statement started at `date`"sqlResult=`$BINDIR/sqlplus -s <<SQLxxxxxxxxxxx/xxxxxxxxxxxxWHENEVER SQLERROR exit 10set feedback offset wrap offset heading offs ...

Oracle Issue in Dataloading using SQLLDR

I am trying ti load data using SQLLDR. I have created the .CTL file and has the .CSV file in one directory. Whenever, I am trying to issue SQL> SQLLDR contrl=controlfile.ctl getting the following error: under WIN2KPro.SP2-0734: unknown command beginning "sqlldr CON..." - rest of line ignored.And ...