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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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…

29-03-2012 9: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

#2 30-03-2012 4:36am

Tom Dunne

Registered Users, Registered Users 2 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