Home » RDBMS Server » Server Utilities » exporting metadata backup (oracle 10g,sun solairs)
exporting metadata backup [message #516574] Tue, 19 July 2011 07:01 Go to next message
zeeshan047
Messages: 61
Registered: June 2010
Location: PAKISTAN
Member

hi,

i am using a schema which i need to take a backup of meta data only i am using exp utility

exp shan/shan@shan file=/backup_dump/shan.dmp log=/backup_dump/shan.log owner=shan rows=n

but it will return me below error, i have only access to user shan our client cant allow me to use system or sysdba schema or any other required grants or privileges so is there any way to take metadata backup of user shan from user shan.



EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

Re: exporting metadata backup [message #516575 is a reply to message #516574] Tue, 19 July 2011 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58957
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The message is clear:
Quote:
Export views not installed, please notify your DBA

Your DBA has to run $ORACLE_HOME/rdbms/admin/catexp.sql script.

Note that exp is NOT a database backup utility and that in 10g you should better use Data Pump instead.

Regards
Michel

[Updated on: Tue, 19 July 2011 07:07]

Report message to a moderator

Re: exporting metadata backup [message #516601 is a reply to message #516575] Tue, 19 July 2011 08:29 Go to previous messageGo to next message
zeeshan047
Messages: 61
Registered: June 2010
Location: PAKISTAN
Member

Thanks for your reply
Excluding EXP utility Is there any other way to take backup of schema containing structure only i.e without data.

Regards
Zeeshan
Re: exporting metadata backup [message #516604 is a reply to message #516601] Tue, 19 July 2011 08:30 Go to previous message
Michel Cadot
Messages: 58957
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Data Pump.

Regards
Michel
Previous Topic: how to use < > operators in WHEN clause sql *LOADER control file
Next Topic: Partition Export Syntax(4 Merged)
Goto Forum:
  


Current Time: Tue Sep 02 06:46:57 CDT 2014

Total time taken to generate the page: 0.16084 seconds