Client Tools :: Command Line Tools

Jan 22, 2011

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.

View 1 Replies


ADVERTISEMENT

Client Tools :: How To Open PL/SQL Developer With SQL WINDOW From Command Line

Sep 11, 2013

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"

View 1 Replies View Related

Client Tools :: Changing DB Password Using SQLPlus Command Line

Jul 21, 2010

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

View 4 Replies View Related

Client Tools :: Running CodeXpert Through Command Line Using Toad 9.0

Oct 20, 2010

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

View 1 Replies View Related

Client Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)

Sep 6, 2010

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)

View 7 Replies View Related

Exadata :: Monitoring Cell Server With OS Watcher / Other Command Line Tools

Aug 7, 2012

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.

View 5 Replies View Related

Client Tools :: Getting Each Record To Output On To One Line

Apr 16, 2010

Using SQL*Plus and having trouble getting each record to output on to one line. The fields I'm querying are:

TEMPLATEID NOT NULL NUMBER(10)
EXPERIMENTID NOT NULL NUMBER(10)
NAME VARCHAR2(200)
CREATEDATE DATE

Obviously, it's the NAME field causing me problems? Have tried using FORMAT, but no change in look of output.

COLUMN TEMPLATEID FORMAT 999999
COLUMN NAME FORMAT A40 WORD_WRAPPED
COLUMN EXPERIMENTID FORMAT 999999

View 7 Replies View Related

Client Tools :: How To Input Line To Sql Script

Aug 27, 2011

I want to put some line in my .sql file. The below is my issue :-

SQL>spool /tmp/Tablespace_Remove.ksh
SQL>echo >#!/bin/ksh---- I want to enter this line to my Tablespace_Remove.ksh
SQL>spool off;

View 3 Replies View Related

Client Tools :: Line Numbering For SQL Developer

Aug 28, 2013

I have a question regarding SQL Developer. When opening a SQL Developer worksheet, there are two different panes or work areas; the upper pane contains the query code and the bottom pane contains the query results (output). Using the

Tools===Preferences tab, I was able to enable line numbering for the top pane (code) but I haven't figured out how to enable line numbering for the bottom pane (results area). how to enable line numbering for the bottom pane?

View 3 Replies View Related

Client Tools :: How To Get Rid Of First EMPTY Line Of Spooled File

May 30, 2011

how to get rid of the first EMPTY line generated by SQL*Plus when spool'ing to a file.

I tried using set pagesize 0 and while that get rid of the empty blank line, it also disabled the heading ...

Currently using sed as a work around. But unfortunately, can't use sed on Windows?

set pagesize 200
set heading on
set trimspool on
set lines 200
set verify off
set echo off
set feedback off

[code].......

As mentioned, using pagesize 0 remove the blank line but I also lost the heading.

View 4 Replies View Related

Client Tools :: How To Remove Dotted Line While Spooling

Jan 27, 2010

i have a issue that when i spool the sql command i get a doted lines below the heading. how to eliminate the doted line but need the heading.

Previous:
OCCUPACODE OCCUPADESC
-------------------- -----------------------------------
1 BUSINESS
2 SERVICE

Needed :
OCCUPACODE OCCUPADESC

1 BUSINESS
2 SERVICE

View 1 Replies View Related

Client Tools :: Change Separator Line Of Compute SUM Or Count?

Jul 9, 2013

Is that possible to modify the ***** and ----- in the TEXT report?

DEPARTMENT_ID JOB_ID LAST_NAME SALARY
============= ========== ========================= ==========
20 MK_MAN Hartstein 13000
************* ********** ----------
sum 13000

From above lines, you can see ****** and ----- which are above sum&13000.

Is that possible to change them as '='?

DEPARTMENT_ID JOB_ID LAST_NAME SALARY
============= ========== ========================= ==========
20 MK_MAN Hartstein 13000
============= ========== ==========
sum 13000
"set underline =" is only shot the headers.

View 3 Replies View Related

Client Tools :: Different Charactersets Show Line-break In Select Result

Mar 22, 2010

i have a little curiosity in result of a select statement.

One database has following characterset settings:

NLS_CHARACTERSET WE8ISO8859P15
NLS_NCHAR_CHARACTERSET AL16UTF16

and the following select statement results in multiple lines:

SQL> select INSTANCE_NAME,STATUS from v$instance;
INSTANCE_NAME
------------------------------------------------
STATUS
------------------------------------
BUP
OPEN

Another database has following characterset settings:

NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

and the same select shows only a 2 line result:

SQL> select INSTANCE_NAME,STATUS from v$instance;
INSTANCE_NAME STATUS
---------------- ------------------------------------
HPSMP OPEN

Both databases are version 10.2.0.4 and both are running on HPUX 11.31.Why do we get this differents in showing the result?

Our problem is that the package-start scripts from HP, to start a database, check the result of the select statement above and if we have the multiline result the check gives an error and stops the package again.

View 3 Replies View Related

Client Tools :: How To Get Command History In Sql*plus Under Windows

Jan 28, 2011

how to get command history in sql*plus under windows

View 2 Replies View Related

Client Tools :: How To Define ED Command In Sqlplus

Jul 25, 2012

In my sql*plus when i am writing the command ed .It was showing the error as \

SQL> ed
SP2-0110: Cannot create save file "afiedt.buf"

i tried to define the editor by using the command define_editor=notepad;

But still my problem was not solved.

View 2 Replies View Related

Client Tools :: SQLPlus Command Parser

Jul 31, 2013

I need to parse .sql file to tree and I can't find how to do it.

(We apply sql files by sqlplus and we have some problems with '/': after anonymous blocks - it haven't applied without '/'; Also not-anonymous block applied twice when we have both ';' and '/'. I need to report about problems before file will apply.) I've tried to use ANTLR with it grammar but it build awful tree.

View 5 Replies View Related

Client Tools :: SQLPlus Not Starting From Command Prompt

Jan 21, 2011

I am able to start SQLPLUS from Start | Program files | Oracle - OraHome92 | Application development |

Unfortunately, when trying to start it from the "command prompt" window with the following command SQLPLUS, it generates the infamous error message like

"... unknown etc... "

Any variables i need to change on my client machine ?

View 11 Replies View Related

Client Tools :: SQL Plus Is Not Recognized As Internal Or External Command

Feb 16, 2011

1) I mistakenly changed my 'oracle_home' some days ago, as below: my computer --> environment variable ...

2) Then i realised that and edit the oracle home and saved as below: C:oracleproduct10.2.0db_1

But i am now not able to open sqlplus. it shows me the below error. 'sqlplus' is not recognized as internal or external command.

View 5 Replies View Related

Client Tools :: Format Output File By Command Spool?

Jan 20, 2011

I use sqplus in oracle to output the command output to text file .

I use below set environment varialble.

SQL> set echo off;
SQL> set linesize 3999;
SQL> set feedback off;
SQL> set feedback off;
SQL> set termout off;
SQL> set pagesize 0;
SQL> spool mapping.txt
select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;

In ouput file , it look like

SQL> select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
060010007 10007
:
:
:
SQL> spool off;

any setting or command that allow me to remove the first sql command line" SQL>select XXXX" and the last command "SQL>spool off" after start up the "spool mapping.txt"

View 8 Replies View Related

Client Tools :: Insufficient Privileges Error While Using Copy Command

May 11, 2012

When i try to copy a table within the database i get insufficient priv error.

SQL> COPY FROM JACK@JACK -
> CREATE T -
> USING SELECT * FROM JACK.T;
Enter FROM password:

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA-01031: insufficient privileges

what privilege is required to perform this copy command ?

View 2 Replies View Related

Client Tools :: Ignore Sql Prompt And Command Entered While Spooling?

Oct 24, 2011

Is it possible to ignore the sql command prompt and the command entered while spooling. I tried the to set echo off,term off and some more options but it did not work.

Example:

SQL> spool c: est.log
SQL> Prompt "This is a test"
"This is a test"
SQL> spool off;

The spool file has the following

SQL> Prompt "This is a test"
"This is a test"
SQL> spool off;

Is it possible to set some options so that the spool file only contains output.

"This is a test"

View 3 Replies View Related

Client Tools :: Handling DATETIME Format Using SQLPLUS COPY Command

Jul 29, 2012

I am using the SQL*PLUS COPY command to move the data from my database to another remote database. The data in my database also contains DATETIME format. But since COPY command cannot handle DATETIME format, I am wondering is there any workaround for this.

Note: Due to some limitations, I cannot use other methods like DATABASE LINK or EXPDP/IMPDP commands.

View 12 Replies View Related

Client Tools :: Break And Compute Command Usage To Modify Output

Oct 14, 2010

I tried BRK and COMPUTE commands myself after reading the documentation but its not working...The output of my script is correct but What I want is the information to be displayed on a different way:

Original script for the report:

set serveroutput on size 1000000
set pages 10000
set lines 1000
set arraysize 1
set trimspool on
set heading off
[code]....

The output should be exactly as above as the requirement is this should be in this particular order and how many is the count in each thoroughfare or locality, as shown in the final output, above.

View 3 Replies View Related

Client Tools :: Use Spool Command To Export Data For Other Purposes Within Application

Feb 1, 2012

I would like to use the Spool command to export data for other purposes within the application. We would like to use tab delimiter to seperate the fields but the client wants to know if the text datatype fields can be wrapped in double quotes along with the tab delimiter..

SQL>create table test (id number(2), first_name varchar2(15), last_name varchar2(15),var_no number(4),
type varchar2(1),type_no number(12));

Table created.

SQL> insert into test values(1,'mary','ross',132,'S',12);

1 row created.

SQL> insert into test values(3,'Sue','Bill',432,'S',12);

1 row created.

I tried the below spool command to use tab delimited for all the fields but not sure how to wrap double quotes for only the text fields and also would to have the column names in the 1st row but don't seem to get the full column name in the csv file.

set echo off
set feedback off
set linesize 1000
set pagesize 4000
set trim on
set headsep off
set colsep '' (used tab between the quote)

spool test.csv
select id,first_name,last_name,var_no,type,type_no from test;
spool off

View 10 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related

Client Tools :: Basic Tools For Oracle Version Control

Aug 26, 2011

I'm looking for 3 simple things.

1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.

2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).

3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.

View 9 Replies View Related

Client Tools :: BR*Tools Appearance Not Complete

Jan 16, 2013

I want to use BR*Tools to administer an Oracle database. I have installed BrGUI local, set the JAVA Home variable and edited the brgui.properties file accordingly.I am able to login, but the menues are mising. The login screen is incomplete.

View 5 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved