Drop partitions without affect the status of the indexes
To drop partitions without affect the index status, use below query.
ALTER TABLE <tableName> DROP PARTITION <partitionName> UPDATE GLOBAL INDEXES;
When you encounter the error ORA-28001: the password has expired, execute below queries to resolve this. export ORACLE_SID=< databaseName> sqlplus / as SYSDBA SQL> alter profile default limit password_life_time unlimited; SQL> alter user <userName> identified by <password>; SQL> commit; SQL> exit;
Comments
Post a Comment