OraFAQ Forum: Server Administration » IMporting data to a schema

Home » RDBMS Server » Server Administration » IMporting data to a schema

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

IMporting data to a schema [message #129936]

Wed, 27 July 2005 06:24

darsh_v
Messages: 16
Registered: February 2005
Location: hyderabad

Junior Member

Hi all,

I have a .dmp file and i want to install the data to my schema. Could anyone tell me to use the import utility to accomplish this, or is there any other way to do this.

Any help is appreciated

Thanks

Darshan

Report message to a moderator

Re: IMporting data to a schema [message #129940 is a reply to message #129936]

Wed, 27 July 2005 06:46

Achchan
Messages: 86
Registered: June 2005

Member

in command line type:
imp help=y
You will see parameters for this utility.For more information refere to Oracle documents:
http://oraclesvca2.oracle.com/docs/cd/B14117_01/index.htm

Report message to a moderator

Re: IMporting data to a schema [message #129972 is a reply to message #129936]

Wed, 27 July 2005 09:01

darsh_v
Messages: 16
Registered: February 2005
Location: hyderabad

Junior Member

Actually I am on Oracle client. SO, this utility is not working in command line.

Is there any other way.

Thanks

Report message to a moderator

Re: IMporting data to a schema [message #129974 is a reply to message #129972]

Wed, 27 July 2005 09:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

imp is distributed along with the client (unless you choose not to install ).
look in $ORACLE_HOME/bin

Report message to a moderator

Previous Topic:	MarshallingXAException error during Transaction.
Next Topic:	rename datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 26 22:56:50 CDT 2024