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.

Report message to a moderator

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: 4963
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.

Report message to a moderator

Previous Topic: Insert data into multiple tables from a single datafile
Next Topic: import problem in linux
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 09:48:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.