| full database Refresh [message #317674] |
Fri, 02 May 2008 08:01  |
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
|
Member |
|
|
Hi Experts,
My clients wants me to refresh a database using imp/exp utility.
I had taken the export of the source database.now i want to import the whole database. please let me know the scripts which i am using is correct.
Imp system/manager Full=Y file=name of file.dmp log=name of log.log Ignore=Y
Thanks,
Daniesh
|
|
|
|
| Re: full database Refresh [message #317677 is a reply to message #317674] |
Fri, 02 May 2008 08:09  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
First, export/import should never be used as a database refresh as it is not a backup tool.
If you insist on importing an export file, the target database must be just a skeleton/shell. No objects or users other than those created at database creation.
You did not say how you took the export.
|
|
|
|
| Re: full database Refresh [message #317682 is a reply to message #317674] |
Fri, 02 May 2008 08:17 |
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
|
Member |
|
|
exp system/manager file=name of file.log dump=name of file.dmp full=y
i used this command for export.
In this case, clients want me to use imp/exp utility.
i know that it will be good if we use hot or cold backup.
|
|
|
|
| Re: full database Refresh [message #317710 is a reply to message #317682] |
Fri, 02 May 2008 12:53 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| daniesh.shaikh@gmail.com wrote on Fri, 02 May 2008 09:17 |
i know that it will be good if we use hot or cold backup.
|
Is this a statement or question? In either case, I have no idea what you are trying to say.
As mentioned before, if you do an import into anything other than a skeleton of a database, you will not get what you are looking for. you do know what import does not replace existing objects, but only adds or ignores.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
