If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

DBA question on tablespaces(Oracle)

JackieChan · 2012-03-29 09:00:13

Can I create and update/insert into tables while a tablespace is been increased in size? I have a job to run that will drop some tables, create new ones, some inserts and deletes. But I know the DBA's are to increase the size of the tablespace that these tables are(will) exist in. Will there be a problem if one kicks off…

Options

29-03-2012 10:00am

#1

JackieChan

Closed Accounts Posts: 1,829 ✭✭✭

Join Date: May 2004

Posts: 1634

Can I create and update/insert into tables while a tablespace is been increased in size?
I have a job to run that will drop some tables, create new ones, some inserts and deletes. But I know the DBA's are to increase the size of the tablespace that these tables are(will) exist in.
Will there be a problem if one kicks off while the other is happening?

0

Comments

Options
#2 30-03-2012 5:36am
Tom Dunne

Registered Users Posts: 23,212 ✭✭✭✭

Join Date: May 2001

Posts: 21052

JackieChan wrote: »

Will there be a problem if one kicks off while the other is happening?

No, you will be fine.

Increasing a tablespace size is really only adding a datafile and this can be done while the database is up and running and DML/DDL actions are in progress.

0