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

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

540


What is key preserved table?

561


What is truncate oracle?

530


How to rename an index?

588


How to write a query with a left outer join in oracle?

605






Explain the use of file option in exp command.

601


Is it possible to insert comments into sql statements return in the data model editor ?

2063


What is null value in oracle?

636


Query to retrieve record for a many to many relationship ?

2077


How does oracle handle read consistency?

679


What is the maximum limit on the number of columns in a table?

551


please explain.. DB architecture ...

1557


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1700


How to rename an index in oracle?

616


What is oracle join syntax?

570