I am getting the error in the text file like
SP2-0042: unknown command "UNION" - rest of line ignored.
I am getting this error in between 300 and 350.
This is my SQL script
WHENEVER SQLERROR EXIT SQL.SQLCODE;
WHENEVER OSERROR EXIT SQL.OSCODE;
set serveroutput on
set newpage 0
set space 0
set pagesize 0
set echo off
set feedback off
[code]....
I want run sql connection and command in one line , something like this ...
sqlplus "/as sysdba" 'select * from dual'
is it possible to do it in one command ?
I have some Oracle Databases and sometimes for me is easier to access to the databases with SQLPLUS instead SQLDEVELOPER or TOAD.
But i can't reach to a good configuration of command line prompt to do queries against the database, normaly if it returns a lot o rows and columns it is unreadable.
I've created a Java class in my Oracle DB that calls a Visual Basic program to convert a XLS file into a CSV file in order to load it into an external table. The problem that I have is that when I call the Visual Basic program from the Java class, nothing happens. I had the same problem with a Python program, and I thought that the problem was from Python, but now with Visual Basic the problem remains, both aren't executed.
The strange thing is that when I call the same Java class outside Oracle, directly from a command line, it executes both Python and Visual Basic programs.
Here is the Java class defined in Oracle:
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "OSCommand" AS
import java.io.*;
public class OSCommand{
public static void Run(){
try
{
[code]....
And here is the procedure that calls the Java class:
create or replace
procedure run_os_command
as language java
name 'OSCommand.Run()';
I am new to SQL*loader and I would like to know what is the maximum number of ROWS that can be loaded in a Conventional bind array while specifying the command line parameter.
View 2 Replies View Relatedi am trying to run DBCA from unix command line. but it gives me error like this:
dbca[158]: /home/oracle/product/10.2.0/jdk/jre/bin/java: not found.
Also i tried to open some other utilites too. like netca it gives me same error.
When I try to connect using the mysql command line, I keep getting an error, I type this exactly:
SQL > Connect
Enter user-name: system
Enter password: (left blank b/c i can't type anything there)
and when I press enter I get the error, null password given, login denied.
We have siebel server on windows machine and db server on unix box. We have done some modification(added columns) in siebel tools level. Now we want to ddl synch through command line prompt. how ot do ddl sync?
View 4 Replies View Relatedfind VIP in RAC from command line.
View 2 Replies View Relatedhow to write this in sql command lineDisplay CUSTOMER number, name, rep, balance, and credit limit for all CUSTOMERs of Rep 20.
In addition, display this information for CUSTOMERs of rep 65 who have a $10,000 credit limit. Arrange the output by credit limit descending within rep ascending. no more than two decimal digits
I am trying to run PL/SQL Developer from command line, So it can open with an opened SQL WINDOW by default, with a script (which I specify in the command ) already in it:
I've tried:
"C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb
but it just opens the application with a connection, no file.
*CORRECTION* While I was writing this post, I tried something , which is not so sophisticated, and it appeared to work...
C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb "C:Program Files (x86)PLSQL Developerandrey.sql"
I'm trying to change a password. I can connect to the db then at the SQL prompt I'm using:
alter user <name> identified by <new password>
The dos window comes back with '2' - then just sits there
I need to run Toad codexpert using command line I am trying the following command
"C:Program Files... oad.exe" CX="C:... CmdLineTest.ini"
When I execte the command from command line .Codeexprt run and stop after some time and it make entry in the error log as "ora-00942 table or view does not exist".
I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow keys on my keyboard. This is quite easy when I am using a shell, but here with this Oracle command line interface it is not working at all. Here is the example as what actually is happening whe I press the up or down arrow keys.
SQL> drop table mailorders;
Table dropped.
SQL> ^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A
The way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)
I'm working with sqlldr and i try to insert data from a csv file to a CTL file. One field of my table contains 5 characters but one row has 6 characters in this field, so it's rejected by oracle. (Logical, you can't insert 6 chars in a 5 chars field)
an error is visibly returned, so i wondered how you could catch the value of this error?is it a code? a message?
I'd like to add to my script a condition so that the end of the script would continue even if this error code is returned for that CTL execution.
is it currently possible to install the supporting objects using sqlplus?
When I export an APEX application which contains supporting objects (scripts to install images, css files, tables and seed data) I can run this script on the command line using sqlplus to install the application into the target environment.
After installing the application (which works fine), I cannot invoke the installation of the supporting objects nor the upgrade of the the supporting objects.
Am I overlooking the obvious, have checked APEX_APPLICATION_INSTALL but there is no function available for that purpose?
we can't use the Exadata Plugin for Cloud Control but we need some monitoring of the Cell Servers.Does OS Watcher is the right tool or do we need ADRCI for incidents and so on.
What do have to install and what information do we get.
I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
the batch file is as follows
D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'
I usually work in oracle using the different editors like toad, plsql developer etc. I felt command line is good utility because of various supporting points. I am not sure what kind of command line tools is available/used. I am using pretty straight command line
(run->cmd, then enter username and password).
The best command line tools available. What is generally used command line tools.
The below query is taken from the procedure
SELECT l_stafnum = stafnum,
category,
duty,
date,
signon,
signoff,
l_rest = rest,
valid,
FROM SESSION.valid_pf
WHERE invalid != 'I'
In the above query has set of data which each staff may have more than one duty.
For example
stafnum categoy duty date signon signoff rest valid
232 M a/c 2/3/12 5:00 8:00 12:00 I
232 M Sup 2/3/12 10:00 13:00 8:00 I
111 M Clen 2/3/12 9:00 12:00 12:00 I
232 M Sw 2/3/12 15:00 20:00 12:00 I
111 M Wp 2/3/12 10:00 14:00 06:00 I
121 M a/c 2/3/12 5:00 8:00 12:00 I
The select query will retrieve the value which mentioned this example.Now, First I need to take how many duty has been allocated for each stafnumber.
232 staff allocated to three duty (a/c,sup,sw) Then need to compare signoff value for first row addition of rest value for the same row i.e, i = 08:00+1200
Then need to compare value of signon for the same staff 232 for the second row which is 10:00 if (i>10:00) then valid;
how I can take same staff number and find it how many duty the staff has.And how to take sign off and rest field value of first row, for the same staff then compare those value with the same staff number second row signon value.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
We are processing spatial data from another source to display in our GIS environment. The data is a set of multi lines. The gtype is 2006. A typical geometry looks like:
SDO_GTYPE 2006
SDO_SRID 31370
SDO_POINT.X NULL
SDO_POINT.Y NULL
SDO_POINT.Z NULL
SDO_ELEM_INFO (1,2,1, 7,2,1)
SDO_ORDINATES (105094.84, 195084.96,
105094.54, 195080.22,
105094.84, 195084.96,
105094.84, 195084.96,
105094.68, 195082.47 )
Now, this is not an actual multiline... it's just encoded as a multi line, but if you look at the coordinates you'll see that the end point of the first line is the same as the beginning of the second line (105094.84, 195084.96).
A better way to encode this geometry would be:
SDO_GTYPE 2002 <---
SDO_SRID 31370
SDO_POINT.X NULL
SDO_POINT.Y NULL
SDO_POINT.Z NULL
SDO_ELEM_INFO (1,2,1)
SDO_ORDINATES (105094.84, 195084.96,
105094.54, 195080.22,
105094.84, 195084.96, <---
105094.68, 195082.47 )
Is there a standard function in Oracle that does this conversion for me? Or do I have to write my own :)
Is it better to use UNION (or) UNION ALL with DISTINCT,Which one will improve performance.
Query1:
SELECT deptno FROM emp
UNION
SELECT deptno FROM dept
Query2:
SELECT DISTINCT * FROM(SELECT deptno FROM emp
UNION ALL
SELECT deptno FROM dept)
I mean to say query1 is better (or) query2 is better,which query improves the performance.
primary key constraint on transaction_dtl_bk is affecting the insertion of next correct rows.
CREATE OR REPLACE PROCEDURE NP_DB.san_po_nt_wnpg_1 (
dt DATE
)
IS
v_sql_error VARCHAR2 (100); -- added by sanjiv
v_sqlcode VARCHAR2 (100); ---- added by sanjiv added by sanjiv
[code]...
Any documentation supporting Oracle 11G and Advanced Security stating encryption at rest is FIPS 140-2 compliant?
View 3 Replies View Relatedwhile i log on to the oracel, i get the following error "Ora-12705 - Invalid or unknown NLS parameter value specified" AND i could not log on. how can i rectify this problem?
View 7 Replies View RelatedI am facing problem with my application while it tries to connect to the Oracle 9i DB using OCI, it fails with ORA-12705: invalid or unknown NLS parameter value specified.
On my client side, the oracle ennvironment variable for the NLS are
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=american_america.we8iso8859p9
same is on the RDBMS side.
SQL> show parameter NLS_LANG
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN
When i try to do a manual connect with sqlplus, it succeeds
$sqlplus /nolog
SQL> connect oltpgen/oltpgen@TSTPOOL
Connected.
I have tried 'unsetting' the NLS_LANG parameter on the client side but did not work.
We are attempting to configure/use OEM (Oracle 10.2.0.4) on Solaris, and when logging in to OEM we are directed to the Database Down page, stating Enterprise Manager is unable to connect to the database instance, but showing all the components as up/open. After checking the log, I found the following error:
IO exception: Unknown Encryption or Data Integrity algorithm
I checked the settings in emoms.properties and compared the encryption parameters to those in our SQLNet file, and all match up. We are NOT using Grid Control, just db control connecting to 1 instance.
I get this error when I try to connect to this database service as another user. I can connect to it as sys without any problem and the database is up.
And when I check to see whether the listener is running for that service, using lsnrctl status command, it shows that the service is UNKNOWN. What does this status mean?
> sqlplus usera/password@prod
SQL*Plus: Release 9.2.0.5.0 - Production on Tue May 25 14:50:35 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 25-MAY-2010 22:56:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xxx)(Port=1521))
STATUS of the LISTENER
[code]....
When I am trying to take backup with partition_options=merge parameter I am getting following error.
Quote:
C:Windowssystem32>expdp system/xxxx directory=mydumps_dir dumpfile=backupdb_01Sep13.dmp tables=abc.dir_transm partition_options=merge logfile=expfdp.log
Error message.
LRM-00101: unknown parameter name 'partition_options'
