AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Oracle 10g online test2/13/2023 ![]() TEST TABLEA_IDX_ID01 TEST TABLEA VALID TABLEA_TBL OWNER INDEX_NAME TABLE_OWNER TABLE_NAME STATUS TABLESPACE_NAME SQL> select OWNER, INDEX_NAME, TABLE_OWNER, TABLE_NAME, STATUS, TABLESPACE_NAMEįrom dba_indexes where TABLE_OWNER='TEST' and TABLE_NAME='TABLEA' SQL> select name, type, owner from all_dependencies where referenced_owner = 'TEST' and referenced_name = 'TABLEA' Run the following SQL commands and save the output in a spool file, such as MATERIALIZED_VIEW_LOG (Materialized view logs) D ![]() The following dependent (D) database objects can be dropped when a table is expdp \"/ as sysdba\" directory=EXPDP_DIR dumpfile=tableA_UNPAR.dmp logfile=tableA_UNPAR.log TABLES=TEST.TABLEAĮxpdp \"/ as sysdba\" directory=EXPDP_DIR dumpfile=tableA_metaunpar.dmp logfile=tableA_metaunpar.log TABLES=TEST.TABLEA content=metadata_only ![]() Run the following code to create a full export backup of the table, TABLEA. This example changes the non-partition table, TABLEA, Use the following steps to change a non-partition table to a partition table by Starting with Oracle® 10g, you can partition tables online without anyĪpplication downtime by using the DBMS_REDEFINITION package.
0 Comments
Read More
Leave a Reply. |