Windows :: How To Run Dos Command From Sqlplus Prompt
Feb 19, 2008how to run dos command from sql prompt.
i.e.
SQL>!DIR
Same can be done in unix using ! character.
SQL>!ls -lrt
ADVERTISEMENT
Client Tools :: SQLPlus Not Starting From Command Prompt
Jan 21, 2011I 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 ?
How To Do DDL Sync On Windows Machine Through Command Line Prompt
Mar 26, 2013We 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 RelatedWindows :: How Search Specific String In PDF File From Command Prompt
Nov 21, 2012I 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 RelatedSqlplus And MS Windows Command Line
Feb 18, 2013I 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.
Connecting To Oracle 10g Via Command Prompt?
Jul 5, 2010I 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) ?
Real Application Clusters :: Check Archive Mount Point Size From Sqlplus Prompt?
Feb 15, 2013I 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
Access TNS_ADMIN Value In Oracle Through Command Prompt
Jul 6, 2012I 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:>
Reports & Discoverer :: RTF Report Execution Through Command Prompt?
Dec 7, 2012is it possible to call the .rtf report through command prompt (ms dos), narrate the procedure.
View 1 Replies View RelatedServer Utilities :: Schema Export In Command Prompt Mode?
Jan 6, 2012I 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.
Client Tools :: Ignore Sql Prompt And Command Entered While Spooling?
Oct 24, 2011Is 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"
Sqlplus Copy Command
Feb 15, 2013i 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 ?
Client Tools :: How To Define ED Command In Sqlplus
Jul 25, 2012In 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.
PL/SQL :: Executing SQLPLUS Command From Stored Procedure
Aug 28, 2012I 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]....
Client Tools :: SQLPlus Command Parser
Jul 31, 2013I 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.
Client Tools :: Changing DB Password Using SQLPlus Command Line
Jul 21, 2010I'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
Oracle Installation Error On Ubuntu-sqlplus / Command Not Found
Mar 5, 2011tried 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]....
Client Tools :: Handling DATETIME Format Using SQLPLUS COPY Command
Jul 29, 2012I 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.
Client Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)
Sep 6, 2010The 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)
Client Tools :: SQLPLUS Windows In Oracle 11g
Feb 27, 2011the reason for not availability of ISQLPLUS & SQLPLUSW window from oracle 11g.
View 3 Replies View RelatedClient Tools :: Windows 7 / Oracle 10g - Not Getting Editor From Sqlplus
Jan 29, 2012I 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 ?
Pass Variables For UserID And Password To Sqlplus In Windows From Text File?
Jul 23, 2013I 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
Windows :: Rename Command In Dos
Mar 13, 2011I want to rename
cf(1)
cf(2)
cf(3)
to
cf1
cf2
cf3
in DOS.
How To Structure Output Using Windows Command
Sep 4, 2008The 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
Client Tools :: How To Get Command History In Sql*plus Under Windows
Jan 28, 2011how to get command history in sql*plus under windows
View 2 Replies View RelatedBrtools Command Versus Oracle Command For Shutdown And Startup (statistics)
Sep 13, 2013we 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 RelatedPrompt User For Value
Apr 29, 2010What 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?
PL/SQL :: How To Call Procedure From Sql Prompt
Jun 12, 2012I have a procedure with signature as proc_temp(deptno in number, empdetails out sys_refcursor);
how can i call this procedure from sql prompt.
Forms :: How To Hide Text Prompt
Jul 27, 2011I 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...
Suppress Prompt When Deploying PSU In Auto
Aug 2, 2012Whenever 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