Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to get a list of schemas on an oracle9i database

how to get a list of schemas on an oracle9i database

From: Alan <nomorezpam3_at_hotmail.com>
Date: 27 Sep 2004 12:41:18 -0700
Message-ID: <84f54f12.0409271141.5e4710be@posting.google.com>


is there a sql command that will give me a list of schemas in an oracle9i database; I've looked through the other postings that ask this and I'm just not seeing the results I need (e.g. select username from dba_users, etc).

Is there an answer or have I got this all wrong?

Thanks Received on Mon Sep 27 2004 - 14:41:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US