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

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1626


What suggestions do you have to reduce the network traffic?

551


How can we force the database to use the user specified rollback segment?

562


if you ctreate table identity

1849


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1618






How can I get column names from a table in oracle?

538


How will you write a query to get a 5th rank student from a table student_report?

1381


How do I start tns listener?

542


Explain enable novalidate constraint.

599


List the various oracle database objects?

602


How to generate query output in html format?

571


candidate key is subset of super key but not vice-verse explain

1583


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1938


How to loop through data rows in the implicit cursor?

545


How to connect to a local oracle 10g xe server?

539