| exporting metadata backup [message #516574] |
Tue, 19 July 2011 07:01  |
zeeshan047
Messages: 99
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  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
