imp-help-urgent [message #54714] |
Sat, 30 November 2002 02:06 |
shareef
Messages: 72 Registered: November 2002
|
Member |
|
|
hi
dear dba guru's
i want to know about importing,for which i do not know the user name from which it was export and the database name, and size.
please help me about this.
with best regards
|
|
|
Re: imp-help-urgent [message #54742 is a reply to message #54714] |
Mon, 02 December 2002 15:06 |
sharan alva
Messages: 57 Registered: November 1999
|
Member |
|
|
YOu do not need to know the above. If someone were to give me an export dump file... I can do a full import into an equivalent version of the database or higher on any platform.
imp dbauser/dbauser file=expdat.dmp full=y log=imp.log
There are other options also .
This should do it.
Get familiar with the oracle utilities manual - this is simple and straight forward...
|
|
|
Re: imp-help-urgent [message #54755 is a reply to message #54714] |
Tue, 03 December 2002 04:56 |
ssa
Messages: 8 Registered: November 2002
|
Junior Member |
|
|
it is not working it giving error, help more me about this. the error message giving as follows.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
with best regards
|
|
|