Re: Oracle Design

From: Lai <lyekheng_at_hotmail.com>
Date: Wed, 17 Mar 1999 17:02:22 +0800
Message-ID: <36ef6f58.0_at_news.cyberway.com.sg>

>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. Received on Wed Mar 17 1999 - 10:02:22 CET

This message: [ Message body ]
Next message: Lars-Fredrik Smedberg: "JDBC Thin drivers"
Previous message: Lai: "SQL Tuning Question"
Maybe in reply to: Chris McFadden: "Re: Oracle Design"
Next in thread: Christopher M. Day: "Re: OO4O: SQL*net or Net8"
Reply: OraSaurus: "Re: Oracle Design"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message