| |
Posted: Jan 07, 2007 08:18:43 AM |
Total Post: 4
Joined: Dec, 2006
|
Thanks in advance..
Please explain the steps to import a .dmp file after fresh installation of Oracle 9i in a server machine ..
Eg:creating users,table spaces etc. ,imp command (to import .dmp)steps in sequence..
Thanks
Liz |
|
|
 vikas |
| Posted: Jan 08, 2007 04:52:19 AM |  |
|
Total Post: 10
Joined: Oct, 2006
|
hello
u can use OMWB utility for import database.
|
|
|
|
|
| |
| Posted: Jan 08, 2007 05:08:38 AM | |
|
Total Post: 4
Joined: Dec, 2006
|
Sorry I have no idea about usign this tool ..what about using normal imp command and creating users etc.
Thanks
Liz
|
|
|
|
|
| Noman |
| Posted: Jan 14, 2007 04:01:12 AM | |
|
Total Post: 14
Joined: Dec, 2006
|
1) you have to create user with create user command
2) create the tablespace and assign that tablespace to the user and temp for the tempory.
3) Assign the Qota on the tablespace.
4) Assing the role that must be import and export role or what ever you role assing. I suggest you first assign DBA role. Remeber after importing the user you should to revoke the DBA Role. if its not the DBA User.
5) import has to be done by two methods one is parfile and second is type the imp command on the command prompt.
Parfile method
-----------------
USERNAME=ABC/ABC
FILE=C:/ABC.DMP
LOG=C/:ABC.LOG
FROMUSER=XYZ
TOUSER=ABC
now i think you have much clear the import procedure.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
