| saza |
Posted: Apr 29, 2008 02:51:36 AM |
Total Post: 13
Joined: Apr, 2008
|
Need some help please!
I want to import a database, got two files exp_er1.gz , and exp.er1.log
How can i do soo??
|
|
|
 GOPU |
| Posted: Apr 29, 2008 03:04:58 AM |  |
|
Total Post: 242
Joined: Apr, 2008
|
" exp_er1.gz " this is a zipfile ?
you can import the dump like this
imp username/passwd file=/filepath/exp_er1.dmp statistics=n buffer=20000
|
|
|
|
|
| saza |
| Posted: Apr 29, 2008 03:15:14 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
exp_er1.gz " this is a zipfile ?
you can import the dump like this
imp username/passwd file=/filepath/exp_er1.dmp statistics=n buffer=20000
Thanks for the answer!!
Yea file name is exp_er1.gz
let me try it
|
|
|
|
|
| saza |
| Posted: Apr 29, 2008 03:22:28 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
mm well i am not sure about it the file.
its just standing its a GZ file .
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 29, 2008 03:33:32 AM | |
|
Total Post: 79
Joined: Apr, 2008
|
unzip the .gz file
>gunzip file_name.gz
you will get a file_name.dmp file then
impdp system/password directory= directory_name dumpfile=file_name.dmp full=y
|
|
|
|
|
| balaji |
| Posted: May 31, 2008 03:54:02 AM | |
|
Total Post: 43
Joined: May, 2008
|
during import/export we use statistics=none.what does it mean??
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
