delete
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 […]
Delete large numbers of instances in Oracle SOA Suite 11g
Purging composites instances in Oracle SOA SUITE 11g There are several ways to purge large amounts of instances in SOA Suite 11g database – dehydration storage; By dropping the SOA Suite repository and next, to recreate it using RCU creation utility providing exactly the same credentials. By executing a set of existing database procedures delivered […]
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…
