| Why no body answer , me is it difficult? [message #85588] |
Sun, 11 July 2004 06:47  |
Ahmed
Messages: 36
Registered: November 2000
|
Member |
|
|
Hi,
I finished a project for a shop that sales computer parts,
and I want a full guide of how to export/import database files,
please guide me step by step?
I will be pleasure.
Thanks a lot.
ahmed...
|
|
|
|
|
|
| Re: Why no body answer , me is it difficult? [message #85593 is a reply to message #85588] |
Sun, 11 July 2004 21:59  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Ahmed,
Export & Import are meant for backup & restoration of Logical data structures and not the Physical onses.
So , let me know what do want,do you want to back up datafiles?
If yes then fire quer of V$datafiles ,V$contrlfiles & V$lofiles to check what are the files use by your DB & what is there location.
Shut down your DB & simply copy them.
If you want logical backup & restore then make use of
EXP & IMP utilities.
As suggested by Frant, go through the documentation,try your hands & then let us know if you face any problems.
Regards
Himanshu
|
|
|
|
|
|
| Re: Why no body answer , me is it difficult? [message #112310 is a reply to message #85588] |
Thu, 24 March 2005 06:10 |
lntchiyoda
Messages: 3
Registered: March 2005
Location: Baroda
|
Junior Member |
|
|
You can either use the IMPORT/EXPORT utility or write the following command on command prompt
c:\exp userid=x full=y log=c:\temp\error.log file=c:\z.dmp
where x is the name of the Database user
z is the export file name
use imp instead of exp for import.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
