Database Administration (MOSC)

MOSC Banner

[10.2.0.4] resize datafile

edited Feb 21, 2010 7:09AM in Database Administration (MOSC) 21 commentsAnswered ✓
Hi, I've got a lot of free space in my datafile (one datafile for one tablespace).
I want to reduce the size of my datafile.
Here are the steps I follow :
1) export tablespace (compress=n) => dump
2) drop tablespace
3) create tablespace
4) import full of my dump

Did I forget something ?

Rgds,

Frederic

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