Re: DBV connect to PDB - anyone know how?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Sat, 22 Oct 2022 19:18:57 -0400
Message-ID: <CAP79kiSfucDUQb9ta3R-Sgnfc740K9w2a+RJ_uWxK4tDWy8QVw_at_mail.gmail.com>



Figured out a work-around

Grant execute on SYS.DBMS_DBVERIFY to SYSTEM in the PDB;

On Sat, Oct 22, 2022 at 7:15 PM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> I want to run dbv against segment_ids in my _PDB_ .
>
> However I cannot figure out how to connect DBV to the PDB as sysdba.
>
>
> https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-dbverify-utility.html#GUID-371A0917-9267-4704-8CF3-6E5120034B9A
>
> Basically it takes USERID=<username/password>_at_db_name
> SEGMENT_ID=xxx.xxx.xxx
>
> I can connect as myself but not as sysdba though I haven't tried SYSTEM so
> maybe that will work which I'll try now.
>
> BUt if anyone knows, I'd be much appreciated.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 23 2022 - 01:18:57 CEST

Original text of this message