eMarcel.com

Oracle Database, Fusion Middleware, Linux

drop

Types of SQL Statements

    A Data Manipulation Language (DML) is a family of computer languages used by computer programs and/or database users to insert, delete and update data in a database. Read-only querying, i.e. SELECT, of this data may be considered to be either part of DML or outside it, depending on the context.   A Data […]

, , , , , , , , , , , , , ,

Drop multiple tables from users schemas

Scenario: To drop, truncate multiple or all tables from user’s schema. Let’s suppose we’ve got the following tables in user’s schema and we want to drop them all: SELECT table_name FROM user_tables; TABLE_NAME —————————— CUSTOMER PRODUCT TIME GEOGRAPHY TODAYS_SPECIAL_OFFERS PURCHASES 6 rows selected Execute statement which will create set of statements ready to be copied […]

,

Redo Online Logs: add clear move delete

After default database 10g installation usually we’ve got 2-3 redo log files in 2-3 groups: SQL>select GROUP#, member from v$logfile; GROUP# MEMBER —— —————————————– 1 /u01/app/oracle/oradata/DBSID/redo01.log 2 /u01/app/oracle/oradata/DBSID/redo02.log 3 /u01/app/oracle/oradata/DBSID/redo03.log Let’s make some changes and create 3 additional members on a different mount point…

, ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close