Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN Summary Script question
Find out the schema owner for your RMAN tables:
select owner,table_name from all_tables where table_name like 'RC%';
as user SYS you will need to use the fully_qualified table_name unless the RMAN schema owner has created a public synonym for them...
"Steven L. Sesar" <ssesar_at_mitre.org> wrote:
>Hmm, I think that I need some basics, here. When I run it, I get:
>
>SQL> @report.sql
>USER is "SYS"
>FROM rc_backup_datafile
> *
>ERROR at line 2:
>ORA-00942: table or view does not exist
>
>
>FROM rc_backup_datafile
> *
>ERROR at line 5:
>ORA-00942: table or view does not exist
>
>
>Sybrand Bakker wrote:
>> On Wed, 07 May 2003 13:13:18 -0400, "Steven L. Sesar"
>> <ssesar_at_mitre.org> wrote:
>>
>>
>>>Can anyone tell me the proper way to run this script?
>>
>>
>>
>> Sure. It's just an ordinary sql*plus script, querying the RMAN tables.
>> It shouldn't be run using RMAN.
>>
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed May 07 2003 - 14:26:41 CDT