Does oracle limit the number of columns we can have in a table? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Does oracle limit the number of columns we can have in a table?

  1. #11
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    DB_BLOCK_SIZE

    Hi tomate,

    u can just query the v$parameter and you can find the size of ur DB_BLOCK. (as told by omegamark)

    it is correct that u cannot change the DB_BLOCK_SIZE once you created the database and if u wanna change you hv to recreate the database.

    but still u can check ur init.ora file.


    --------------------------
    The Time has come ....

  2. #12
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    In Oracle 7.x version the number of columns is 256 whereas in Oracle 8 onwards the number of columns is 1000.
    Regarding ur insertion of data u can insert as much data as u can till space is not a constraint on ur machine.
    In case of any help please be free to ask me at rohitsn@altavista.com

    REgards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width