First, you should have a database created that has the particular
tablespace(s) that contain the data in question before the import. What
I do is open the dump file in a text editor like WordPad or TextPad
(READ ONLY!!!) and copy/paste the create tablespace statements into a
text file and use those statements as a reference to creating my
database prior to importing the dump file.

HTH,
Stephen

Stephen Price
Oracle Database Administrator
Compusearch Software Systems, Inc.

-----Original Message-----
From: Balvinder Singh
[mailto:oracledba-ezmlmshield-x13380748.[Email address protected]
Sent: Thursday, June 28, 2007 2:23 AM
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



Oracle LazyDBA home page