Posted by Mir Sayeed Hassan on 30th October 2021
ORA-14404: partitioned table contains partitions in a different tablespace Got the below error, While dropping a tablespace. SQL> drop tablespace TEST1_TBL including contents and datafiles; drop tablespace TEST1_TBL including contents and datafiles; *ERROR at line 1: ORA-14404: partitioned table contains partitions in a different tablespace Check any contains… Read more..
Posted in ORA-Error | Comments Off on Error while dropping tablespace: ORA-14404: partitioned table contains partitions in a different tablespace
Posted by Mir Sayeed Hassan on 4th October 2021
How to configure the memory target in Oracle Database Consider you are running the database with sga & pga configuration., if you need to change it to memroy target, fallow the below process. Check the status of database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ———————————————- oemsw… Read more..
Posted in DBA Administration | Comments Off on How to configure the memory target in Oracle Database
Posted by Mir Sayeed Hassan on 4th October 2021
How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0) Overview of recovery catalog The recovery catalog contains metadata about RMAN operations for each registered target database. therefore when RMAN is connected to a recovery catalog, the RMAN obtains its metadata exclusively from the catalog db, to perform this operation you need to Read More
Posted in RMAN | Comments Off on How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0)
Posted by Mir Sayeed Hassan on 2nd October 2021
ORA-65162: The password of the common user has expired The above error is occur due to the user password was expired in your database Check the status of the user SQL> select username,account_status from dba_users where account_status like ‘%EXPIRED%’; USERNAME ACCOUNT_STATUS —————————– SYSTEM EXPIRED Check… Read more..
Posted in ORA-Error | Comments Off on ORA-65162: The password of the common user has expired
