Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to Organize Tables according to Case Studies

684110Feb 9 2009 — edited Mar 19 2009
There are two class projects that I am working on - a Library Database and another one on Video Rental.
I would like to keep the tables that I create for these projects separate.

I thought of using prefixes like LIB_ and VID_ for the two sets of tables. Is there a better way? I do not
have privileges of creating a user.

The Oracle database is currently running at the University and I am accessing it through SQL Developer.
There is a connection name that I am using right now. Would using two different connection names
create two different namespaces?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 16 2009
Added on Feb 9 2009
3 comments
417 views