How to define Data Block size ?

Answer Posted / orawhiz

A data block size is specified for each ORACLE database when
the database is created. A database users and allocated free
database space in ORACLE datablocks. Block size is specified
in INIT.ORA file and cann't be changed latter.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of save points in oracle database?

533


various types of hints and their usage

2131


What is the usage of analyze command in oracle?

611


What do you mean by group by clause?

563


What happens to indexes if you drop a table?

698






How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1805


How to lock and unlock a user account in oracle?

612


Explain user account with reference to oracle.

533


What is the difference between substr & instr functions?

597


what are steps for interface? where is exchange rate defined in which table?

1497


What do you mean by a tablespace?

564


How to rename an existing table?

607


How to insert a new row into a table in oracle?

589


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

643


Is rowid unique in oracle?

528