Home » RDBMS Server » Server Utilities » import .dmp file (Oracle 10G, version 10.1.2.0)
import .dmp file [message #424068] Wed, 30 September 2009 03:12 Go to next message
latu.patel
Messages: 4
Registered: September 2009
Junior Member

Hello Friends,

As i have .dmp file which is exported by someone else and just now i have to import this file into my oracle server. version is 10.1.2.0. now I have created database with the help of database configuration assitant now i want to import my .dmp file to my db...how i can?

i m much familiar with SQL Server 2005 but not with Oracle that much...please help me....as i am waiting for answer...
Re: import .dmp file [message #424078 is a reply to message #424068] Wed, 30 September 2009 03:40 Go to previous messageGo to next message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member

Hi,
Wrong Forum for posting this question....

Anyways you can use IMP command for importing oracle dumps.
use command prompt for this

eg.
C:\>IMP <username>/<password>@<TNSNAME> file=c:\dumps\dmp_file.dmp

for more help http://www.orafaq.com/wiki/Import_Export_FAQ

[Updated on: Wed, 30 September 2009 03:50]

Report message to a moderator

Re: import .dmp file [message #424094 is a reply to message #424078] Wed, 30 September 2009 04:15 Go to previous messageGo to next message
latu.patel
Messages: 4
Registered: September 2009
Junior Member

Hi,

i have try that cmd at sql prompt by doing login in my new database

SQL > imp system/manager file=d:\lrims\lrims.dmp

but i got this error:

SP2-0734: unknown command beginning "IMP SYSTEM..." - rest of line ignored.

please help me..and sorry i have posted first mesg do in hurry i forgot to change the forum topic.....






Re: import .dmp file [message #424097 is a reply to message #424094] Wed, 30 September 2009 04:26 Go to previous messageGo to next message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member

u need to wirte it at DOS(c:\) or Unix(#) command prompt not SQL(sql>) prompt(sql>)

C:\>IMP <username>/<password>@<TNSNAME> file=c:\dumps\dmp_file.dmp
Re: import .dmp file [message #424105 is a reply to message #424097] Wed, 30 September 2009 04:44 Go to previous messageGo to next message
latu.patel
Messages: 4
Registered: September 2009
Junior Member

Sorry Ashish for disturbing again...

have try that on DOS prompt but now i m stucked with Oracle version problem...

when i tried to import the datbase i got error like:

Export file created by EXPORT:V10.02.01 via convetional path..


so can i upgrade this? or any patch for this??

please help me..
Re: import .dmp file [message #424115 is a reply to message #424105] Wed, 30 September 2009 04:58 Go to previous messageGo to next message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member

Can you tell me what command you typed on DOS promt
Re: import .dmp file [message #424129 is a reply to message #424115] Wed, 30 September 2009 05:25 Go to previous messageGo to next message
latu.patel
Messages: 4
Registered: September 2009
Junior Member

please see attached file for error..
Re: import .dmp file [message #424148 is a reply to message #424129] Wed, 30 September 2009 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is no attached file.

If it is not too big, copy and paste it in the post, do not attach a file, many of us can't or don't want download files.

Regards
Michel

[Updated on: Wed, 30 September 2009 06:03]

Report message to a moderator

Re: import .dmp file [message #424157 is a reply to message #424148] Wed, 30 September 2009 06:22 Go to previous messageGo to next message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member

(I dont like spoon feeding but just coz my mood is good.... Smile )

these are the steps for data import.

c:>imp
Import: Release 9.2.0.6.0 - Production on Thu Mar 29 15:07:43 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: SYSTEM
Password: password
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Import file: expdat.dmp > /mention/path/of/dumpFile/includingFileName.dmp
Enter insert buffer size (minimum is 8192) 30720> (press enter to accept default)
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
List contents of import file only (yes/no): no > press enter
Ignore create error due to object existence (yes/no): no > press enter
Import grants (yes/no): yes > press enter
Import table data (yes/no): yes > press enter
Import entire export file (yes/no): no > press enter or type no
Username: give the userName for which you want the data to be imported
Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: press enter
. importing TST_001_V2's objects into TST_001_V2



Re: import .dmp file [message #424204 is a reply to message #424105] Wed, 30 September 2009 13:00 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
latu.patel wrote on Wed, 30 September 2009 05:44
Sorry Ashish for disturbing again...

have try that on DOS prompt but now i m stucked with Oracle version problem...

when i tried to import the datbase i got error like:

Export file created by EXPORT:V10.02.01 via convetional path..


so can i upgrade this? or any patch for this??

please help me..


If export was done by 10.2.1, then you cannot import it into 10.1.2.0. You will need at least that version of the import utility.
Previous Topic: Merge two identical databases/schemas.
Next Topic: Why imp very slower then exp
Goto Forum:
  


Current Time: Mon Dec 23 20:23:23 CST 2024