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

How to assign values to variables?

813


if you ctreate table identity

2114


How to list all user accounts in oracle?

806


How to turn on or off recycle bin for the session?

818


How to view all columns in an existing table?

713


How many types of database triggers exist?

758


How to load excel data sheet to oracle database

760


What is max rowid in oracle?

772


How do we get field detail of a table?

823


What is a subquery?

826


How to view the tablespaces in the current database?

749


How to write date and time literals in oracle?

738


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1833


How to pass parameters to procedures in oracle?

795


what are archived logs?

1938