why database fill only one datafile of tablespace ?
database tablespaces give error mail to me. It says TABLEINDEX haf %2 free size. But I looked, only 5.th datafile filled %85 and others are not filled (%0 or %1) all datafiles are 32 GB. I send photo. These are in TABLEINDEX tablespaces... And I send tablespace command. Any problem? What should i do? I know when one datafile filled, it will continue other datafiles. but It gives " %2 free space " message.
And here is my tablespace command.
CREATE TABLESPACE "tableindex" DATAFILE SIZE 34358689792 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 32767M, SIZE 34358689792 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 32767M, SIZE 1048576 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 32767M, SIZE 10485760 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 31744M, SIZE 10485760 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 31744M, SIZE 10485760 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 31744M, SIZE 10485760 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 31744M, SIZE 10485760 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 31744M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO ALTER DATABASE DATAFILE '+DATA/MATRIX/DATAFILE/tableindex.293.882277141' RESIZE 34358689792 ALTER DATABASE DATAFILE '+DATA/MATRIX/DATAFILE/tableindex.282.882278143' RESIZE 33285996544 ALTER DATABASE DATAFILE '+DATA/MATRIX/DATAFILE/tableindex.281.882278145' RESIZE
0