Dr. Codd's rule states that data dictionary should be the ultimate reference point for all database objects. I understand that tablespaces are also part of the database object definitions and hence my query about violation of Codd's rules.....
Originally posted by sundaju But tablespaces were part of DD
Dr. Codd's rule states that data dictionary should be the ultimate reference point for all database objects. I understand that tablespaces are also part of the database object definitions and hence my query about violation of Codd's rules.....
Which Codd's rule are you refering to? No rule of Codd mentions tablespaces.
I was testing the use of LMT's on a test database. From a 14MB dump file, when I import it into a dictionary managed tablespace, it fills up 24 MB. But when the same dump is imported into an LMT, it need 340MB of datafile space.
I know this sounds crazy, but does anybody have any explanations for this. Also when creating a LMT what is the difference between extent autoallocate and uniform size.
Uniform extents will cause Oracle to allocate extents of uniform size in the tablespace. If the initial extent size is greater than this size, then Oracle will allocate enough uniform extents to match the amount of space requested for the initial extent.
On the other hand, when AUTO ALLOCATE is used, Oracle uses an internal algorith to control the extent sizes.
Reply With Quote
Bookmarks