How to define Data Block size ?

Answer Posted / nishi

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 can't be changed latter.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primefaces used for?

559


Explain oracle 12c new features for developers?

540


When do I need to use a semicolon vs a slash in oracle sql?

594


When do you get a .pll extension in oracle? Explain its importance

577


How to Truncate Table in Oracle

659






What is a package in oracle?

567


Give the constructs of a package, function or a procedure.

543


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.

1617


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1741


What is difference between sid and service name in oracle?

520


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

614


How to write an inner join with the where clause in oracle?

587


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558


Explain coalesce function?

630


Explain the use of parfile option in exp command.

528