Home » RDBMS Server » Server Utilities » Importing dmp file - first time (Oracle 10g XE on Windows Server 2003)
Importing dmp file - first time [message #403318] Thu, 14 May 2009 15:18 Go to next message
bluntz
Messages: 4
Registered: May 2009
Junior Member
Hi all, I'm a complete newbie with Oracle, never used it once. I'm a quick learner though so please bare with me.

I have to setup an Oracle server for my company and so I downloaded and used the default options to install Oracle 10g XE on Windows Server 2003. Now I have some tables I need to import from a dmp file created in Oracle 9i.

I've read that I need to use the 'imp' command in order to do this but I have no idea how and I don't even know how to access the command line for Oracle. This should be a one time thing so they would rather have me figure it out than to hire an expert - so any help is appreciated!!

Here are the tables I need to import:
tables=(addterm_tags,stopword,Wilsonfiles3,lookup_list,NHWWTBL,RELNHWWTBL,TERMSSBIO,RELSBIO,SEARCHNHWWTBL,TERMSSRDG,RELSRDG,SEARCHSRD G,SEARCHSBIO,TERMSSBPI,RELSBPI,SEARCHSBPI,TERMSSGEO,RELSGEO,SEARCHSGEO,TERMSSPSB,RELSPSB,SEARCHSPSB,TERMSSCSB,RELSCSB,SEARCHSCSB)


If you need any other information, just post a reply and I will check back often. Thanks again!
Re: Importing dmp file - first time [message #403319 is a reply to message #403318] Thu, 14 May 2009 15:30 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
the import utility is "imp" so issue following command:
imp help=yes

You will need to create a target schema/user to own the tables & data

[Updated on: Thu, 14 May 2009 15:31]

Report message to a moderator

Re: Importing dmp file - first time [message #403320 is a reply to message #403319] Thu, 14 May 2009 15:33 Go to previous messageGo to next message
bluntz
Messages: 4
Registered: May 2009
Junior Member
where do i run that from though?
Re: Importing dmp file - first time [message #403322 is a reply to message #403320] Thu, 14 May 2009 15:43 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Operating system command prompt.
Previous Topic: DMP FILE IMPORT
Next Topic: Impdp with multiple dump file directories
Goto Forum:
  


Current Time: Sat Dec 03 06:20:51 CST 2016

Total time taken to generate the page: 0.14761 seconds