Windows :: How To Run Dos Command From Sqlplus Prompt

Feb 19, 2008

how to run dos command from sql prompt.

i.e.
SQL>!DIR

Same can be done in unix using ! character.

SQL>!ls -lrt

View 6 Replies


ADVERTISEMENT

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

How To Do DDL Sync On Windows Machine Through Command Line Prompt

Mar 26, 2013

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 Related

Windows :: How Search Specific String In PDF File From Command Prompt

Nov 21, 2012

I have a requirement in which i have list pdf files(from thousands of pdf files) having particular string from a command prompt.I have tried find command but that has some limitation. its working upto 3 digit string only.how can i acheive this.remember i have to do this through command prompt only.

View 1 Replies View Related

Sqlplus And MS Windows Command Line

Feb 18, 2013

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.

View 5 Replies View Related

Connecting To Oracle 10g Via Command Prompt?

Jul 5, 2010

I decided to uninstall oracle 10g, and APEX 4.0.

I then reinstalled oracle 10g express and downloaded APEX 3.2..

However, wen its time to upgrade to APEX3.2 via the command prompt... the previous version of APEX 4.0 (11.1.0.6.0) is being read.

how to reset this to the original value 10.2.0.10 (10g express edition) ?

View 1 Replies View Related

Real Application Clusters :: Check Archive Mount Point Size From Sqlplus Prompt?

Feb 15, 2013

I am in need to find archive log mount point space detail usage through sqlplus on multiple instance. Is there any view in oracle which can give me the detail.

I know one method using external table but that is cumbersome for RAC.

can i get some command like this.

select inst_id,mountpoint,space_usage,space_available,total from GV$table --> returns

View 4 Replies View Related

Access TNS_ADMIN Value In Oracle Through Command Prompt

Jul 6, 2012

I am trying to get the TNS_ADMIN value but I m an not getting Expected Results . My tnsNames.Ora are located at the following locations : -

1) C:oracleproduct10.2.0client_1NETWORKADMIN
2) C:oraclexeapporacleproduct11.2.0server

NetworkADMIN

As you can see from the belowcode, TNS_ADMIN is not displaying the correct location.

C:>set TNS_ADMIN=%ORACLE_HOME%
etworkadmin

C:>echo %TNS_ADMIN%
%ORACLE_HOME%
etworkadmin

C:>echo %ORACLE_SID%
%ORACLE_SID%

C:>

View 4 Replies View Related

Reports & Discoverer :: RTF Report Execution Through Command Prompt?

Dec 7, 2012

is it possible to call the .rtf report through command prompt (ms dos), narrate the procedure.

View 1 Replies View Related

Server Utilities :: Schema Export In Command Prompt Mode?

Jan 6, 2012

I want to take a export of schema JACK of size 700 MB which contains list of objects in it.

SQL> select count(*),object_type from dba_objects where owner='JACK' group by object_type;
COUNT(*) OBJECT_TYPE
---------- -------------------
207 INDEX
4 PROCEDURE
190 TABLE
80 VIEW
3 SYNONYM
67 SEQUENCE

6 rows selected.

The export command i am going to use is as below.

exp system/oracle@ORCL1 file=schemaexp.dmp log=schemaexp.log owner=JACK rows=y direct=y
grants=N constraints=y COMPRESS=N buffer=100000000 RECORDLENGTH=64000

Is it possible to take this schema export in windows command prompt mode and any guess how long it would take to complete the export ?Because based on the time it takes, i am going to perform the export in windows command prompt.

View 3 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

Sqlplus Copy Command

Feb 15, 2013

i am trying to copy the data from a remote database which has Oracle 8i thru Sqlplus copy command to the local database which has Oracle 11gR2.

copy from abc/abc@remote
insert emp_new
using
select *
from emp_old
where rownum < 1001;

is it possible to copy the remote database thru sqlplus copy command ?

View 6 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

PL/SQL :: Executing SQLPLUS Command From Stored Procedure

Aug 28, 2012

I am trying to execute the SQLPLUS command (CONNECT) from the stored procedure.It is throwing below error message.

Stored Procedure:

SQL> select user from dual
2 ;
USER
------------------------------
SYS
SQL> create or replace
2 PROCEDURE PROCEDURE1 AS
3 BEGIN
4 sqlplus sys/sys@D as sysdba;
5 --execute immediate 'create user 'kkk' identified by 'kkk';
6 END PROCEDURE1;
7 /

Warning: Procedure created with compilation errors.

SQL> show err
Errors for PROCEDURE PROCEDURE1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/9 PLS-00103: Encountered the symbol "SYS" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "SYS" to continue.
[code]....

View 29 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 :: 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

Oracle Installation Error On Ubuntu-sqlplus / Command Not Found

Mar 5, 2011

tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:

rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
[color="#000000"][/color]
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found

i have also tried to set the oracle_home, oracle path & oracle SID.

find the below configuration parameters which i have set to.

root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`

[code]....

View 4 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 :: 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

Client Tools :: SQLPLUS Windows In Oracle 11g

Feb 27, 2011

the reason for not availability of ISQLPLUS & SQLPLUSW window from oracle 11g.

View 3 Replies View Related

Client Tools :: Windows 7 / Oracle 10g - Not Getting Editor From Sqlplus

Jan 29, 2012

I am using Windows 7 and oracle 10g; From sqlplus* I can not use editor (using ed). but when I see the variable from DEFINE.. It shows that default editor is notepad..

I can use editor in winxp.How to get (use) editor ?

View 1 Replies View Related

Pass Variables For UserID And Password To Sqlplus In Windows From Text File?

Jul 23, 2013

I would like to store user-id, password and the TNS-Entry in a small text file and pass them to a script to log in and execute another script on the database from Windows.

Example of the text file samp.txt that stores user info:

username=Jdoe
password=candybar
db_sid:orcl

main script main.bat is as follows:

--read the samp.txt do not know how to do it

sqlplus -s &username/&password@&db_sid @db_info.sql

db_info.sql contents:

column tm new_value file_time noprint
select to_char(sysdate, 'YYYYMMDD') tm from dual ;
spool C:\server\DB_Report_&file_time..log
select * from v$instance;
spool off;
exit

View 1 Replies View Related

Windows :: Rename Command In Dos

Mar 13, 2011

I want to rename

cf(1)
cf(2)
cf(3)

to

cf1
cf2
cf3

in DOS.

View -1 Replies View Related

How To Structure Output Using Windows Command

Sep 4, 2008

The output below is looked mass..

1) the capital letter is the name of column

2) consists 8 data for each column name

Quote: STATISTICS_DATE INSTANCE_NAME GENESIS_PORT
-------------------- ---------------------------------------------------------------- ------------
COUNT TOTAL_TIME MAX_TIME MIN_TIME AVERAGE_TIME
--------- ---------- --------- --------- ------------

03-AUG-08 MatlMgr_UpdateInstance140028
35 6.8685906 .83870006 .06330299 .19624545

View 2 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

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?

View 3 Replies View Related

Prompt User For Value

Apr 29, 2010

What is the function to prompt a user for a value when running a script and where would it be used?

I was also wondering if it is possible to populate a list from a table that would be displayed in a drop down box for the user to choose from?

View 1 Replies View Related

PL/SQL :: How To Call Procedure From Sql Prompt

Jun 12, 2012

I have a procedure with signature as proc_temp(deptno in number, empdetails out sys_refcursor);

how can i call this procedure from sql prompt.

View 2 Replies View Related

Forms :: How To Hide Text Prompt

Jul 27, 2011

I have created a text prompt in layout editor by clicking a button 'TEXT'('A' symbol) from left hand side toolbar,text is created with name 'TEXT67' and graphics type 'TEXT'.

when i click that text(TEXT67),block showing <null>.

So i cant use the below code,bcoz no block for that text..

SET_ITEM_PROPERTY('<BLOCK_NAME>.<TEXT_NAME>',PROMPT_TEXT,' ');

then i tried below,i.e i skip block name i gave only text name..

SET_ITEM_PROPERTY('TEXT67',PROMPT_TEXT,' ');

not working...

View 2 Replies View Related

Suppress Prompt When Deploying PSU In Auto

Aug 2, 2012

Whenever I deploy a PSU patch I receive the prompt below. I'm attempting to deploy PSU in an automated fashion. How do I suppress the prompt? "Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):"

View 0 Replies View Related







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