973642 wrote:You don't want any further transactions to happen on that tablespace. You want to transport that tablespace.
I have a couple of questions regarding Read-Only Tablespace.
1)What are some reasons to take a tablespace readonly?
2)Are READ-ONLY tablespaces performed better than READ-WRITE tablespaces for select type transactions?You need to get the basics correct. There is nothing like select type transactions . Select doesn't modify or lock anything in Oracle db.