Help me with schema backup [message #342802] |
Mon, 25 August 2008 02:57 |
dirki
Messages: 2 Registered: August 2008
|
Junior Member |
|
|
Hi,
I am trying to backup the schema for one particular user. I use the Exp utility:
exp.exe login@server file=testdb.dmp owner=testdb
But when I use the Imp utilitiy to import the data the system
wants the user to be already there. Is it possible to backup
both user(+roles etc...) and schema in one go?
Many thanks for your help in advance,
Dirki
|
|
|
|
Re: Help me with schema backup [message #342811 is a reply to message #342806] |
Mon, 25 August 2008 03:39 |
dirki
Messages: 2 Registered: August 2008
|
Junior Member |
|
|
I understand the fromuser and touser parameters. But my exported schema data somehow relies on user roles of that user. So, I'd like to re-create exactly that user before importing data.
If Exp is not a valid backup method for a schema, what tool should I use instead?
Can I export a user and import him before re-creating the data?
Dirki
|
|
|
Re: Help me with schema backup [message #342817 is a reply to message #342811] |
Mon, 25 August 2008 04:03 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
exp/imp cannot satisfy all your requirements.
You have to add other things to create the other objects (user, roles, privileges) for instance querying the dictionary table and/or using dbms_metadata package.
Regards
Michel
|
|
|