Oracle database - Explain how to resize tablespaces and data files posted by
Babu Kunwar
Explain how to resize tablespaces and data files
Oracle provides different types of tablespace namely SYSTEM tablespaces, the
SYSAUX tablespace, temporary tablespaces, undo tablespaces, and bigfile
tablespaces.
The procedures and methods available for resizing a tablespace are slightly
different, depending on whether the tablespace is a smallfile or a bigfile
tablespace.
Smallfile case I:
For example we need to alter the size of the table space named users which
contain one database file starting out of 5 MB. First we will make it to 15 MB
and then reduce its size to 10 MB.
SQL> alter database datafile '/u01/app/oracle/oradata/rmanrep/users01.dbf'
resize 15m;
SQL > alter database datafile '/u01/app/oracle/oradata/rmanrep/users01.dbf'
resize 10m;
Bigfile Case II:
A bigfile tablespace consists of one and only one datafile. Remember:
Operations that are valid only at the datafile level with smallfile tablespaces
can be used with bigfile tablespaces at the tablespace level
SQL> alter tablespace bigfile_name resize 1g;
More links
What is a Database Table?
How many types of tables supported by Oracle? Explain them.
Can you explain how to create a aew table in your schema?
Explain with an example how to create a new table by selecting rows from
another table.
Depict a sample script for renaming an existing table.
Sample script to drop an existing table.
How to Add a new column to an existing table?............
|
