eMarcel.com

Oracle Database, Fusion Middleware, Linux

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…

, ,

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