Re: Oracle Design

In article <36ef6f58.0_at_news.cyberway.com.sg>, "Lai" <lyekheng_at_hotmail.com> wrote:
>>Second thot, was to use different table space to seperate the sets of
>>tables. To access the tables in each set, change the default tablespace for
>>the user to reference that tablespace containing the required tables. Is
>>there any potential problem with this design?
>>
>Table name is unique at database level, not at tablespace level. So, you
>can't use this method. If you use a different table name, then which
>tablespace the table is in is immaterial.

Not exactly... Table names must be unique at the schema level.

• OraSaurus --
• Remove "not_" to reply... --