|
-
I suppose if you have one machine that can connect to all the databases, you can write a small script that does something like this.
Have a small control file (assuming you want all the passwords to be the same), which just contains
alter user sys identified by xxxx;
alter user system identified by xxxx;
then assuming you have a list of all the 114 sid's or connect strings, you can create a script which generates a list of commands
sqlplus sys/password@db1 @control.sql
sqlplus sys/password@db2 @control.sql
Then just run that script.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|