Re: RMAN error: ORA-01031 Insufficient privileges

From: <gnewsgroup_at_gmail.com>
Date: Wed, 5 Dec 2012 04:58:40 -0800 (PST)
Message-ID: <736c9722-2ede-4060-a1bb-828e75df1b79_at_googlegroups.com>

On Wednesday, December 5, 2012 3:05:46 AM UTC-5, Eric wrote:
> On 2012-12-05, gnewsgroup_at_gmail.com <gnewsgroup_at_gmail.com> wrote:
>
> >
>
> ...
>
> >
>
> > SQL> select count(*) "total_count" from hr.employees;
>
> >
>
> > total_count
>
> > -----------
>
> > 107
>
> >
>
>
>
>
>
> Which proves that you have a *schema* called HR, not a tablespace! You
>
> appear to be operating in a fog of insufficient knowledge.
>
>
>
> Eric
>
> --
>
> ms fnd in a lbry

I ran SELECT * FROM DBA_USERS; and found that the default tablespace of HR is Users.

So, the question becomes what I should do to backup only HR instead of everything in the Users tablespace.

If you'd like to offer a reference to Oracle documentation, please be more specific (instead of doc.oracle.com). Thank you. Received on Wed Dec 05 2012 - 13:58:40 CET