Urgent Problem about GB and TB level database

[swandream]

I don't know about Oracle very well, But I was asked to answer him a question about very large binary object database:
If the data of a record is very large, about 500M - 1T Bytes, which choice would be better for putting all the records into only one table or creating multiple tables with the same fields,each table only store one record?
Does Oracle has the fields limit such as no more than 256 ?
Does it has records limit such as no more than 1,000,000?
I hope somebody could help me, answer all the questions above, thanks.

[tamilselvan]

1. In Oracle 8i/9i, you can store BLOB in a separate tablespace. The max limit is 2GB for a single object. You do not need to create multiple tables. All you need to do is separate data and BLOB in 2 different tablespaces.

2. The max number of columns is 1000.

3. There is no physical limitation for the number of rows. However, it depends upon the block size and the number of data files created for the table.

[swandream]

tamilselvan, thank you.

[marist89]

closing, duplicate thread http://www.dbasupport.com/forums/sho...threadid=32701