A DBA might experience the situation in which a disk drive needs to be removed because it keeps encountering errors. Perhaps a new disk drive has been added to the system, and some of the redo log members need to be placed on the drive. Whatever the case, redo log members can be quickly renamed or moved by using alter database from within Oracle Server*Manager or SQL*Plus.
To move the file physically from one location to another, specify the name of the file to move and its destination. In the following example, redo1a.log is moved from its present location, /u03/oradata/norm, to its new location, /u06/oradata/norm:

These Oracle PL/SQL tutorial videos are an excellent insight in to the relational Database model and the Oracle Architecture. The tutorial assumes no prior knowledge of Oracle PL/SQL and subsequently is an ideal reference and learning aid for beginners. Authored by Oracle PL/SQL expert Gavin Powell this tutorial offers a clear and practical insight by means of high quality narrated QuickTime movies, this tutorial is also a suitable reference for the Oracle Certification (1Z0 007 ). Topics covered include: PL/SQL Tools, iSQL, Table Creation, Constraints, Indexes, Security, Privileges, Using SELECT INSERT and other Functions, Strings, Joining Tables, Sub Queries, Triggers, Variables, Explicit Cursors. Of course this is only a small section of what is covered on the PL/SQL tutorial, if you would like to see the entire content listing and view a free demo follow the link below.

This Week we will be learning "Restricting and Sorting Data" covers the following topics. WHERE Clause - Comparison Operators; Logical Operator; Using the Logical Operator, AND; Using the logical Operator, OR; Using the Logical Operator, NOT; Nesting Logical Operators; Other Comparison Keywords; Using the Keyword, LIKE; Using the Keywords, BETWEEN...AND; Using the Keyword, IN; Using the Keyword, IS NULL ORDER BY Clause - Using the ORDER BY Clause

This topic includes over 300 technical documents and bulletins published by Oracle Worldwide Customer Support. These documents contain useful technical information, alerts, sample scripts and other sample files. We have organized the documents to correspond to the chapters listed in this book (shown below). Although some of the documents here might seem outdated, we have included them because we believe that each one of them presents useful concepts that should benefit all levels of Oracle users.
e have downloaded these documents from various sources at Oracle Worldwide Customer Support and attempted to organize them by chapters corresponding to the book, as shown here:

With DBMoto, users define data replication and transformations by applying business rules and mapping. Unlike other solutions, DBMoto offers unlimited control over data replication and transformation using programming or scripting technologies. DBMoto supports two mapping methods: automatic mapping, where source field values are duplicated for the target table, and manual mapping. Both methods can be optionally controlled programmatically or via scripts. DBMoto also includes a powerful expression generator for interactive data transformation.