Q

ORA-00942: table or view does not exist

We recently did a system refresh from PRD to TEST. After that, our backup failed in TEST with the following error.

We recently did a system refresh from PRD to TEST. After that, our backup failed in TEST with the following error. We are running R/3 4.6C, Oracle 9.2 (with BR tools 6.4).
 
BR0051I BRBACKUP 6.40 (25)
BR0055I Start of database backup: bdtjahza.anf 2006-08-26 10.00.38
BR0280I BRBACKUP time stamp: 2006-08-26 10.00.39
BR0301E SQL error -942 at location BrLicCheck-32
ORA-00942: table or view does not exist
BR0056I End of database backup: bdtjahza.anf 2006-08-26 10.00.39
BR0280I BRBACKUP time stamp: 2006-08-26 10.00.39
BR0054I BRBACKUP terminated with errors
I do not recognize the messages from the backup utility you are using. These are not Oracle messages nor RMAN messages. However, the ORA-00942 error shows your problem. The user the backup utility connects to the database with most likely does not have permissions to select from a table or view. You'll have to figure out which tables or views this utility needs and grant appropriate access for that user.
This was first published in September 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close