Will resizing a tablespace have effect on users logged onto the database and using objects from that tablespace? Will it affect affect other appllications using that tablespace as well?
Printable View
Will resizing a tablespace have effect on users logged onto the database and using objects from that tablespace? Will it affect affect other appllications using that tablespace as well?
No affect until and unless u reduce the size and their are inserts/updates which causes the HWM of objects to increase beyond the reduced size.
No.
Resizing of datafile is safe and transparent to users and applications.
If you try to set wrong size, you get ORA-xxxxx error, nothing bad.
However, take a backup of your production database whenever
you change its structure, which includes altering the size of datafiles.
thanks guys