I ran the following query to get the actual and max size of my datafiles:
select file_name, sum(bytes)/1024/1024 "actual size MB",
sum(maxbytes)/1024/1024 "max size MB"
group by file_name;
In the query result, I found some actual size greater than the max size (like for my rollback datafile:
Datafile : rbs1.dbf
Actual size : 300
Max size : 200
How can you get a file that exceed the max size specified during the tablespace's creation?
In the case you would need it, here's how I created the rollback datafile:
CREATE TABLESPACE ROLLBACK
DATAFILE 'rbs1.dbf' SIZE 10M REUSE AUTOEXTEND ON
NEXT 10M MAXSIZE 200M
DEFAULT STORAGE ...
[Edited by els on 12-14-2000 at 12:31 PM]