I got it, it's sounds more practical, TQ. But is there any limitation of
how many databases i can create into the database container ?

Is the same implementation can apply for the Oracle 8i or IBM DB2
database ?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Chen Fock Siong wrote:

> I got it, it's sounds more practical, TQ. But is there any limitation of
> how many databases i can create into the database container ?

I don't think there's a software limitation, but there is a non-trivial amount
of disk spaces needed for each database...

> Is the same implementation can apply for the Oracle 8i or IBM DB2
> database ?

I don't know much about DB2, but Oracle cannot do this, having multiple
databases within a given DBMS instance. You would have to have separate
running instances of oracle, one for each company (not practical).
The approach that would be most easily transferable would be to have a
different schema (user) for each company. In oracle, a fully defined tablename
is <schema>.<tablename>, such as scott.company, where 'scott' is the user
that created the table.
Let's revisit the reason you want to avoid one table. You said that the table
would get very big. That may be true, but many applications successfully use
very large tables. With the appropriate indexes, the DBMS can usually make
your important queries very efficient.
Joe Weinstein at BEA

>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!