Home » SQL & PL/SQL » SQL & PL/SQL » How to create the shortcut
How to create the shortcut [message #1756] Mon, 27 May 2002 06:07 Go to next message
shiva
Messages: 38
Registered: March 2001
Member
I have to have a new shortcut which will export the entire database.How should i go about it.
Or
Is it possible to create a batch file in dos please
give the reply with coding as it will be a great help
Re: How to create the shortcut [message #1759 is a reply to message #1756] Mon, 27 May 2002 07:12 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a short cut where ever you want.
right click the short cut.
go to parameters and in target field
enter the following information( like shown below).
<full path for exp.exe><database username/password@servicename><parmeterfile>

eg:

D:OracleOra81binEXP.EXE mag/mag@high9i parfile=c:params.dat

here the params.dat shall contain the following

FILE=c:mag.dmp
GRANTS=y
FULL=y
ROWS=y

where FILE=C:MAG.DMP tells where to place the exported dump file.

----------------------------------------------------
thats it.
save the shortcut.
when you click the shortcut, it should work.
Previous Topic: Undefined select with DBMS_SQL
Next Topic: help me...please
Goto Forum:
  


Current Time: Thu Apr 25 23:45:44 CDT 2024