Table and its count

Table and its count - Oracle

To get the number of rows in all tables in Oracle database, use this query.

SELECT table_name,num_rows FROM all_tables WHERE owner = 'SCHEMA';

Comments

What need to do when encounter the error ORA-28001: the password has expired

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;

Alter auto extent on existing datafile in Oracle

To alter the existing datafile in Oracle database, use below query. alter database datafile '/u01/app/oracle/oradata/XE/system.dbf' autoextend on maxsize unlimited;

Backup database without data in MySQL

To get the database backup with any data, execute below command: mysqldump -u USERNAME -p DATABASENAME --no-data > BACKUPNAME.sql

Databases

Search This Blog