Home » SQL & PL/SQL » SQL & PL/SQL » whats the maximum columns in oracle 9i
whats the maximum columns in oracle 9i [message #266189] Mon, 10 September 2007 02:45 Go to next message
oracleram
Messages: 23
Registered: November 2006
Junior Member
hi every1,
please clarify my doubts whats the maximum columns allowed in
in oracle 9i?thanx in advance.

Thanx & Regards,

Ram
Re: whats the maximum columns in oracle 9i [message #266190 is a reply to message #266189] Mon, 10 September 2007 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle9i Database Reference
Chapter 4 Database Limits
Section Logical Database Limits
Quote:
Columns Per table 1000 columns maximum

Regards
Michel
Re: whats the maximum columns in oracle 9i [message #266203 is a reply to message #266189] Mon, 10 September 2007 03:28 Go to previous message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Quote:

The absolute maximum number of columns in a table is 1000. However,
when you create an object table or a relational table with columns
of object, nested table, varray, or REF type, Oracle Database maps
the columns of the user-defined types to relational columns, in effect creating hidden columns that count toward the 1000-column limit.



I got it from the bellow link.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm
Previous Topic: Trigger
Next Topic: Selecting from a XLS file (merged)
Goto Forum:
  


Current Time: Fri Dec 09 07:36:14 CST 2016

Total time taken to generate the page: 0.06032 seconds