| Import/Export [message #62858] |
Thu, 19 August 2004 23:21  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi.. I've got a .dmp file...Now i want to import entire .dmp file in oracle by import utility...I've tried to do it with imp utility and with parametr FULL=Y... But from the logfile, I came to know that some uers and table from that .dmp file has not been imported.pls guide me how to import entire .dmp file??
thanks,
avra
|
|
|
|
| Re: Import/Export [message #62872 is a reply to message #62858] |
Fri, 20 August 2004 20:48  |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
if you can see from the log file that some users objects have not been imported then they may not have any objects at all.
still if you are sure that some tables have not been imported then use the table imp
with best regards
balaji
|
|
|
|
| Re: Import/Export [message #62873 is a reply to message #62872] |
Fri, 20 August 2004 21:43 |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi Balaji.. Thnx for ur reply... In my logfile, it is showing me some user called Opr1, Opr2 n so on.. but those users are not getting imported...Can you tell me the reason...I've done FULL import....
Is there any third party software for Import/Export??..I've got Easy Dump for Oracle...But it's evaluation version.. So all features are not there...
|
|
|
|
|
|
| Re: Import/Export [message #62923 is a reply to message #62873] |
Tue, 24 August 2004 11:44 |
Girdhari Chudhary
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
|
for easy import/export you can configure the OMS(oracle managment server) and than using OEM you can import you file in full GUI mode. it gives very easy operation rather than command prompt. even on command prompt if you write imp -help, it gives all options for import with detail
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
