Querying Tablespace Usage

Querying Tablespace Usage

If you are an Oracle DBA then you know the importance of tablespaces in the oracle database. In Oracle Database the tablespace management is important and Oracle DBA will need to do quite frequently. So here is a query that providing the tablespace uses details. Query to check the tablespace usage The following query will … Read more Querying Tablespace Usage

Share this
Share

Moving Table & Rebuild Index

REBUILD INDEXES

In this article i’m going to show you how to move a table in new tablespace. Then rebuild indexes which is based on that table, because after moving table all indexes goes invalid. You also read how to Transport Database from Linux to Windows SQL> CREATE TABLE ocp TABLESPACE users AS SELECT * FROM EMP; … Read more Moving Table & Rebuild Index

Share this
Share
Share