Home » RDBMS Server » Server Utilities » Importing specific tables in oracle database using unix
Importing specific tables in oracle database using unix [message #243471] Thu, 07 June 2007 07:03 Go to next message
sghoshal
Messages: 5
Registered: April 2007
Location: Kolkata
Junior Member
I want ti import tables in database usimg unix.

I am using the following script as i don't have enough space in unix to unzip the file

mknod /tmp/imp_pipe p
gunzip -c 060607_0355.dmp.Z >/tmp/imp_pipe &
imp rpd/rpd123 file=060607_0355.dmp.Z fromuser=rpd touser=rpd tables=PARAMETER

rm -f /tmp/imp_pipe

However I am getting the following error.
sh: mknod: not found.

Can anybody please help.
Re: Importing specific tables in oracle database using unix [message #243482 is a reply to message #243471] Thu, 07 June 2007 08:13 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Does mknod exist in your /etc directory? If yes, then security on the system might not allow all users to execute this command.
Previous Topic: Insert data into multiple tables from a single datafile
Next Topic: import problem in linux
Goto Forum:
  


Current Time: Mon Dec 05 15:17:47 CST 2016

Total time taken to generate the page: 0.23974 seconds