Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center