I have a database with three tables. I need to move historic partitioned data to other schema Now that i?m planning to creatre the new "historic" tables. I don?t know how to measure the size of par Table and tablespace location. Finding out who owns a table and what tablespace it is in is a pretty common need of the DBA. In this query, we use the dba_tables view to find the owner and tablespace name of the EMP table. SQL> select owner, table_name, tablespace_name 2 from dba_tables 3 where table_name='EMP'; Mandatory tablespace in database Image taken from Oracle Documentation (Note: Here tablespace is logical ,datafile is physical) Tablespace: Tablespace is logical storage unit in oracle database which consists of one or more datafiles it can't be visible in the data file system . Tablespace Files : Tablespace has different types in above picture i.e Compression attribute can be declared for a tablespace, a table, or a partition of a table. If declared at the tablespace level, all tables created in that tablespace will Table Compression in Oracle Database 10g Release 2 Page 4. added to the SELECT statement of the external table to 3 Tablespaces, Datafiles, and Control Files. Th is chapter describes tablespaces, the primary logical database structures of any Oracle database, and the physical datafiles that correspond to each tablespace.. This chapter contains the following topics: Introduction to Tablespaces, Datafiles, and Control Files ORACLE-BASE - DBA Scripts: default_tablespaces.sql : Oracle database SQL scripts. Articles Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Oracle 13c Oracle 18c Oracle 19c Miscellaneous PL/SQL SQL Oracle RAC Oracle Apps WebLogic Linux MySQL Oracle 10g Release 2 (10.2) yUndo retention auto-tuning further enhanced - Tuned for maximum retention possible for given tablespace - Maximum retention available for fixed ts (85% of size) - For auto-extensible tablespace, same behavior as in 10.1 - Adjusts automatically different workloads - Efficient space utilization yUNDO_RETENTION Read the most frequently asked 100 top Oracle 10g Interview Questions and answers for freshers and experienced job interview questions pdf. Oracle 10g Interview Questions and Answers List. 1. What are the components of physical database structure of Oracle database? Oracle database is comprised of three types of files. data file resizing shrinking tips Oracle Tips by Burleson Consulting April 4, 2014: Question: How do I reduce the size of my Oracle data file sizes? I want to shrink the size of my data files to reclaim un-used space. (Select tablespace_name,sum(bytes) bytes_full From dba_extents Group by Oracle 10g New Features for Administrators (Summary Sheets) v. 2.0 Page 3 Oracle 10g New Features for Administrators (Summary Sheets) Performance Enhancements to the This is a new tablespace introduced in Oracle 10g used as a central location In this article we will discuss about shrinking datafiles to reclaim unused space from the tablespace in Oracle. Below the two scripts to release free space from the datafiles residing on ASM as well as disk. It will work for Oracle 10g, 11g, 12c ..etc.