How to check size of bigfile tablespace. com provides a detailed guide on querying Oracle tablespaces. A tablespace is a database storage unit that groups related logical structures together. As you probably know, the ROWID is used to locate a particular row for a particular table in a tablespace (ie, one of its datafiles). So, if your tablespace is truly a bigfile tablespace, you cannot add another datafile to it. Monitor To check if a given tablespace is a bigfile tablespace: SELECT tablespace_name, bigfile FROM dba_tablespaces; Backup and restore With such large files, bigfile tablespaces can take considerably longer to backup or restore. In the following example, the tablespace users1 is autoextensible. Bigfile is the default file size when creating a new tablespace. It focuses on how to check tablespace size, free space, and differentiate between big file and small file tablespaces using SQL queries. To list the names and various other parameters of all tablespace in a database, use the following query on the DBA_TABLESPACES view: Jan 9, 2007 · Database administrators can now resize Oracle datafiles at the tablespace level using the BIGFILE tablespace feature in 10g. The database data files are stored in tablespaces. otel gehyq hyoyl svyfw ejac gcmjmvj fgtl cgx lygdh ntjcu