Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
In one table...
This is a discussion on In one table... within the Oracle forums, part of the Databases category; What is the maximum column that we could use? And also what is the maximum foreign key in just one table?...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
06-01-2006
|
|||
|
|||
|
In one table...
What is the maximum column that we could use? And also what is the maximum foreign key in just one table?
|
| Sponsored Links |
|
06-04-2006
|
|||
|
|||
|
Re: In one table...
I'm sorry about that! I'm referring to Oracle.
|
|
06-08-2006
|
|||
|
|||
|
Re: In one table...
I think it was 1000 in Oracle 8i.... it depends on Oracle Version , I have never come close to the limit of columns in a table, so I don't pay much attention to the actual limit in each version. I had 325 columns in one table when I was working on Datamart related project...
let me know if you find exact specs and limits from any oracle manuals... I am bit lazy to search 
|
|
06-20-2006
|
|||
|
|||
|
Re: In one table...
You are absolutely right Suji. Oracle8i and later versions allow the user to create table with maximum of 1000 columns. Check out the following url to know other logical database limits (in oracle8i).
http://www.cs.umbc.edu/help/oracle8/...0/ch4.htm#4691 Allan, Answer to your second question is...The maximum number of foreign keys can be defined on a table is unlimited. Thanks, james.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating a table by copying another table's structure | Allan Paul | Oracle | 19 | 04-17-2009 06:03 AM |
| Dual Table in Oracle | janelyn | Oracle | 20 | 03-30-2009 08:10 AM |
| State and temp Records in PeopleSoft | admin | PeopleSoft | 1 | 02-26-2007 06:42 PM |
| Type of Table for Extension Colums | RyanJames | Oracle Apps | 0 | 05-31-2006 10:58 PM |
All times are GMT -4. The time now is 08:46 PM.
