RE: Importing data from dmp file

RE: Importing data from dmp file

 

  

Oracle's import utility never shows you the data directly. If you run
it interactively, it will show you a summary line for each table
something like this:
...importing table table_name ### rows imported.

After the import, you can either open the log file that import created
to see this summary, or you can query the table(s) that import loaded to
see the data.


-----Original Message-----
From: somaraju
[mailto:oracledba-ezmlmshield-x91714163.[Email address protected]
Sent: Thursday, June 28, 2007 3:57 AM
To: LazyDBA Discussion
Subject: RE: Importing data from dmp file

Hi,

Check the exported log file, wheather it has got exported with rows or
not


Regards
Somaraju.I
Off: 040-23110357/8 Ext : 530
Mobile # 98494 20302



-----Original Message-----
From: Balvinder Singh
[mailto:oracledba-ezmlmshield-x13190967.[Email address protected]
Sent: Thursday, June 28, 2007 12:12 PM
To: LazyDBA Discussion
Subject: RE: Importing data from dmp file



Hi,

I use the below syntax to import the dmp file-

imp system/manager file=d:\tempdb.dmp full=y

Thanks
Balvinder

-----Original Message-----
From: Mao Alex (CI/ISY12-CN)
[mailto:oracledba-ezmlmshield-x83525293.[Email address protected]
Sent: Thursday, June 28, 2007 12:04 PM
To: LazyDBA Discussion
Subject: RE: Importing data from dmp file


What's imp sql statement do you use for importing data from dmp file?

-----Original Message-----
From: Balvinder Singh
[mailto:oracledba-ezmlmshield-x13380748.[Email address protected]
Sent: Thursday, June 28, 2007 2:23 PM
To: LazyDBA Discussion
Subject: Importing data from dmp file

Hi,

i have import the oracle data from .dmp file using Imp utility in Oracle
9i.
However it doesn't show me the data anywhere. Could you pls help that
where
it have restored the data.

balvinder


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page