Database Utilities (MOSC)

MOSC Banner

Impdp full database creates smaller tablespaces

Hello,

I am migrating a large 12c database from solaris to x86 using full database expdp and impdp .

While impdp is running it creates tablespaces with smaller files. For example if the source tablespace has 10 datafiles each 30 gb, the import creates some of the files with 10gb in size.

I get the following error

"Resumable error: ORA-01653: unable to extend table"

I have to manually increase the filesize.

Any idea why this is happening?

sample commands:

expdp user/pass directory=somedir dumpfile=dbfull.dmp full=y

impdp user/pass directory=somedir dumpfile=dbfull.dmp full=y

Thanks

Tagged:

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