> Here's what the DBD::Oracle documentation has to say on the topic: > > > In Oracle, the concept of user and schema is (currently) the same. Because > > database objects are owned by an user, the owner names in the data dictionary > > views correspond to schema names. Oracle does not support catalogs so > > TABLE_CAT is ignored as selection criterion. > > Hm, okay, but I'm still not entirely comfortable with setting schema() to > username() thanks to that little "(currently)" bit. Anyway, back to > list_tables(). The docs say:
The use of '(currently)' in the DBD::Oracle documentation is simply wrong. In Oracle, every user has a corresponding schema. The schema is comprised of all objects that user owns. The specific text in the Oracle Database Concepts manual regarding the relationship of a user to a schema hasn't changed in several years except to clarify this point. In particular: Oracle® Database Concepts, 10/g/ Release 2 (10.2) Oracle10g http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm Overview of Schemas and Common Schema Objects A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Going back a bit: Oracle 7 Server Concepts https://webapps.umsystem.edu/oracle73/a32534_1.pdf Chapter 5 Schema Objects This chapter describes the objects that can be created in the domain of a specific user (a schema), including tables, views, numeric sequences, and synonyms. Indexes and clusters, optional structures that make data retrieval more efficient, are also described. Therefore, upon connecting to Oracle, by default the current schema is the name of the current user. As a side note, within a given session, the default schema may be changed using 'Alter session set Current_Schema = <schema-name> ;'. [EMAIL PROTECTED] Senior Oracle Developer Computing Facilities School of Computer Science Carnegie Mellon University ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
