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';
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;
Comments
Post a Comment