OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » schema not found (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

schema not found [message #551159]

Mon, 16 April 2012 01:09

Schmike
Messages: 3
Registered: April 2012

Junior Member

I'm new to oracle and solaris.

I've got a dmp file that I need to restore from. I've managed to successfully restore it in windows but not in solaris.

ran the following command:
$impdp SCHEMAS=<schema> DUMPFILE=<dumpfile> LOGFILE=<logfile>

I got the following error:
SCHEMAS=<schema>: not found

Basically anything after $impdp is always not found. Is there any problem during setup? Setup is done by someone else.

Report message to a moderator

Re: schema not found [message #551161 is a reply to message #551159]

Mon, 16 April 2012 01:12

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste the COMPLETE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: schema not found [message #551164 is a reply to message #551159]

Mon, 16 April 2012 01:21

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Are you typing
$impdp
including the dollar sign? If you are, that would give you the error because Solaris will interpret $impdp as a variable with null content, and then attempt to find a command SCHEMA. The command is
impdp

Report message to a moderator

Re: schema not found [message #551166 is a reply to message #551164]

Mon, 16 April 2012 01:27

Schmike
Messages: 3
Registered: April 2012

Junior Member

Version is 10.2.0.4

After I ran it without the dollar sign, it says impdp not found.

Do I have to reinstall Oracle?

Report message to a moderator

Re: schema not found [message #551169 is a reply to message #551166]

Mon, 16 April 2012 01:31

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Probably not; that would depend on what you HAVE installed so far. If it is just an Oracle client, maybe you didn't install utilities (which includes Export/import data pump). Obviously, you'd run the installer again and install missing components.

Report message to a moderator

Re: schema not found [message #551170 is a reply to message #551166]

Mon, 16 April 2012 01:38

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

You haven't set your search path correctly. Ask your DBA (or system administrator) to explain how to do that, probably by using the
oraenv
script.

Report message to a moderator

Re: schema not found [message #551173 is a reply to message #551166]

Mon, 16 April 2012 01:40

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Actually, since you already know how to run impdp on Windows, why log on to Soalris at all? Just run the import from your Windows machine where you understand all this.

Report message to a moderator

Re: schema not found [message #551175 is a reply to message #551173]

Mon, 16 April 2012 01:42

Schmike
Messages: 3
Registered: April 2012

Junior Member

The problem is that my client is running the database on a solaris and I have to replicate their setup.

Thanks for all the help. I will check with my infra team on the setup again.

Report message to a moderator

Re: schema not found [message #551189 is a reply to message #551175]

Mon, 16 April 2012 03:12

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 16 April 2012 08:12

Copy and paste the COMPLETE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Previous Topic:	overwrite existing dump file in expdp in oracle 10g
Next Topic:	How to find estimated time to complete import (imp)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 07 08:19:06 CDT 2025