Database Administration (MOSC)

MOSC Banner

Tablespaces Storage query

edited Jul 9, 2009 4:08PM in Database Administration (MOSC) 4 commentsAnswered
Dear all

My oracle has a tablespace calls Maximo and contains 1 datafile Maximo.dbf (on E drive and nearly 10g in size) and its storage option is auto-extend to maximo of E drive availabiltiy.

I would like to increase this tablespace - I am thinking to add additonal oracle datafile Maximo1.dbf (on G drive) to the same tablespace.

My concern is:

"Will in event if the exisitng Maximo.dbf run out of spaces; and this new Maximo1.dbf will take over ?"

Basic info:

oracle 10g 10.2.0.1.0 (archive log enable)

OS: window 2003

Many thanks for your help.

Stan Hui

  

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