i had two database 10gr2
first one is prod second one is test for the prod database the compatible parameter is set to 9.2.0
and for test it is set to 10.0.0
i created tablespace in prod
create tablespace prod1 datafile '/u01/app/oradata/prod/prod1.dbf' size 1gb extent management local;
in test database i created tablespace
create tablespace test01 datafile '/u01/app/oradata/test1/test01.dbf' size 2gb;
which statements are true regarding this tablespaces?
1. a bigfile tablespace can not be created in prod database as its compatibility is set to 9.2.0
2.tablespace in test will be locally managed by default as its compatibility is set to 10.0.0
3.all tablespace in prod will be dictionary managed by default?
i suspect that only 3 is wrong
Looks like a test question.
As an exercise for the student and also get truly useful help from the forum, you could use the documentation at tahiti.oracle.com and cite a quotation that either confirms or refutes each statement in turn. Then, explain what you understand or don't understand about each citation. At that point the real gurus will be more than happy to clarify what you are having difficulty with. Such an approach will be far more valuable and beneficial to your career development that for someone to simply reply "yes, yes, no" (or whatever -- DISCLAIMER: MY USE OF "YES, YES, NO" IS MEANT AS AN EXAMPLE. I JUST PULLED THOSE OUT OF THE AIR. THEY ARE NOT INTENDED TO BE THE CORRECT ANSWERS"