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: 4723
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: Sun Apr 23 03:27:06 CDT 2017

Total time taken to generate the page: 0.06427 seconds