why do we give pctfree and pctused in create table statement?
Answer Posted / arul
pctfree and pctused only used for DMT tablespace for extent management allocations
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Which autogrowth database setting is good? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can a session indicate its interest in receiving alerts?
What the different topologies in which replication can be configured? : sql server DBA
internal architecture
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the default fill factor value? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the importance of a recovery model? : sql server DBA
What are the commands used in dcl? : sql server DBA