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
Oracle LazyDBA home page