Convert your database to use a BIGFILE tempfile

The following commands may be used to convert an 11g or 12c database to use a BIGFILE temporary tablespace datafile instead of the default regular file, which is limited to 32GB. BIGFILEs can grow to 32TB.

This can be useful when loading very large amounts of data into a database, for example for a POC test.

Continue reading