Can I use expdp/impdp to recreate a BIGFILE tablespace?
I have a database with one tablespace consisting of a single, 2Tb BIGFILE datafile. I want to recreate the tablepace, using the same name (required), but with non-BIGFILE datafiles. Can I use expdp in tablespace mode to export the data, drop the tablespace, re-create the tablespace with non-BIGFILE datafiles, then use impdp to reload the data? A better option? This is for Oracle 19.3 Enterprise Edition database.