SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a way to run a script accross all database services ?

Asked to LearnApr 7 2020 — edited Apr 13 2020

Hello,

My Database version Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

OS: Windows 10 & Oracle Linux 7.7

I've created two database / services, named ORCL & TESTORCL

so, to connect i've to user sys/password@ORCL

& sys/password@TESTORCL as sysdba.

i want to run a script across two data base and want to generate bellow html reports,

database/services	USERNAME
ORCL	30
TESTORCL	40

CAN I do this, if yes, how ?

Thanks

Ask2Learn

This post has been answered by HamidHelal on Apr 13 2020

Jump to Answer

Added on Apr 7 2020

8 comments

987 views