Hello all,
This question is related to another question in this discussion that was answered for me..thank you there.
I have a COTS product with a script that I'm having to adapt for use. This is on a 5 node RAC system. I'm using ASM and OMF.
Their scripts has the following that I need to adapt for my environment.
ALTER SYSTEM SET db_4k_cache_size=128M;
No problem with that.
However, their create tablespace command seems to be for using regular datafiles on an operating system, rather than ASM and using Oracle Managed Files.
The entry they have is:
CREATE TABLESPACE "TBS4K" NOLOGGING
DATAFILE '<TABLESPACE_LOCATION>/TBS4K.dbf'
SIZE 512M blocksize 4k EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Would I do something like:
CREATE TABLESPACE "TBS4K" NOLOGGING DATAFILE SIZE 512M blocksize 4k EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Or would it be simpler like:
CREATE TABLESPACE "TBS4K" NOLOGGING DATAFILE blocksize 4k ;
Thank you in advance,
cayenne