OraFAQ Forum: SQL & PL/SQL » Maximum No. of columns and Triggers in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » Maximum No. of columns and Triggers in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Maximum No. of columns and Triggers in Oracle [message #204320]

Mon, 20 November 2006 02:48

send2aarti
Messages: 2
Registered: November 2006

Junior Member

Hi All,

Can somebody please provide me with this Info ?

1. Maximum No. of Triggers we can create on a table ?
2. Maximum No. of Columns a table can have in Oracle ?

Thanks,
Art

Report message to a moderator

Re: Maximum No. of columns and Triggers in Oracle [message #204321 is a reply to message #204320]

Mon, 20 November 2006 02:53

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi aarti

1. Maximum No. of Triggers we can create on a table ?
http://www.oreilly.com/catalog/ordevworkbook/chapter/ch16s.html

2. Maximum No. of Columns a table can have in Oracle ?
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm

hope this helps
Taj.

Report message to a moderator

Re: Maximum No. of columns and Triggers in Oracle [message #204325 is a reply to message #204320]

Mon, 20 November 2006 03:04

send2aarti
Messages: 2
Registered: November 2006

Junior Member

Thanks a lot Taj for such a prompt reply !

Appreciated Smile

Report message to a moderator

Re: Maximum No. of columns and Triggers in Oracle [message #204327 is a reply to message #204325]

Mon, 20 November 2006 03:05

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You're welcome.

Report message to a moderator

Re: Maximum No. of columns and Triggers in Oracle [message #204343 is a reply to message #204320]

Mon, 20 November 2006 04:11

dawood
Messages: 5
Registered: November 2006

Junior Member

13 database trigger is been used including instead of trigger.

Report message to a moderator

Re: Maximum No. of columns and Triggers in Oracle [message #204369 is a reply to message #204320]

Mon, 20 November 2006 06:09

moparthy99
Messages: 13
Registered: July 2006

Junior Member

No of columns in 7.x is 254 .now from oracle 8i onwords 1000 cols.
For triggers for one table basically 12 ways we can write.But no,limit for triggers .

Report message to a moderator

Previous Topic:	Table Partition
Next Topic:	UTL_MAIL.send: How to put RECORD in MESSAGE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 17:32:46 CST 2024