Home » RDBMS Server » Server Administration » imp-help-urgent
imp-help-urgent [message #54714] Sat, 30 November 2002 02:06 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: setting unix window buffer size
Next Topic: Check amount of useable temp space
Goto Forum:
  


Current Time: Fri Sep 20 01:28:51 CDT 2024