Attached is an Oracle PL/SQL script that will read the Data Services repository and print out the configurations for each Datastore. This is useful to see in one complete list what all the alias names, users name and database server names are in use.
I take the output of the script and paste into an Excel spreadsheet. The vertical bar ( | ) is used as the token to separate the columns.
Datastore_Configuration_Parser.txt (7.0 KB)
eganjp 
(BOB member since 2007-09-12)
You are my hero of the day 
Script is well documented, I like that.
The part I did not like is that in SQL Plus running the script resulted in a BSOD on my display driver, twice.
Oh well, I’ll look in to that another time.
Johannes Vink 
(BOB member since 2012-03-20)
I have a client that used it with SQLPlus. I only used it with SQL Developer.
It’s still a work in progress as it is almost entirely focused on Datastores connecting to Oracle databases.
eganjp (BOB member since 2007-09-12)
I like your reply! 
Brouch1978 (BOB member since 2014-02-24)