Database Administration (MOSC)

MOSC Banner

Moving Oracle Tablespaces

edited Feb 1, 2011 8:20AM in Database Administration (MOSC) 7 commentsAnswered
 Hi All,

First time poster and Oracle DBA novice here, so please be gentle.

We're in a situation where I've had to add more disk to our Oracle Database server (Windows 2003 R2). What I'm after is a step by step (if possible) on how to move our tablespaces onto the newly created disk. At the same time I want to tidy up the general location and the type of tablespaces. The database/tablespaces have been created by our developers in the past, I now want to take more control over this and I see this as an ideal opportunity of starting this process. At the moment, my understanding is, the tablespaces I need to move

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