Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using command prompt command in pl/sql procedure like IMP

Status
Not open for further replies.
rk68

rk68

Programmer
Jul 15, 2003
172
IN
Is it possible to use command prompt commands like IMP (Import) in PL/SQL procedures.
I want to use the import command in the pl/sql procedure where the user keys in the dump file name in the procedure parameter and the procedure then uses the parameter in the IMP command & imports all the data from the dump (DMP) file.

Is it possible ? If yes, please tell me how ?
I'm using Oracle 9i.

Thanx
RAJ
 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
910
Livia8
Livia8
rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
315
rk68
rk68
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
510
carp
carp

Part and Inventory Search

Sponsor

Back
Top