Create Bigfile Tablespace – Oracle Managed Files (OMF)
Posted by Tyler Muth on February 10, 2012
Working with Exadata a lot (almost exclusively) I create almost all my tablespaces as bigfile using OMF. For some reason I can never find the right syntax for this when I need it. So, that’s the main reason for this post.
CREATE BIGFILE TABLESPACE data1 NOLOGGING datafile '+DATA_DM01' SIZE 50G AUTOEXTEND ON NEXT 5G; CREATE BIGFILE TABLESPACE dbfs_ts NOLOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO datafile '+DBFS_DM01' SIZE 500G AUTOEXTEND ON NEXT 10G;
On a related note, wow I use “column mode” in Notepad++ (link) a lot for this stuff. Many other editors support column mode, including an old favorite on Windows, UltraEdit (link).
database services said
This i have seen in GUI … but now were i was able to locate in both version … thank you for sharing. Your blog seems to be interesting one. I will go through each and every post you have made.