| |
| Oracle DBA FAQ - Oracle Basic Concepts
Posted in Oracle > Miscellaneous by tutorialgrub on Apr 11, 2011
This is a collection of FAQ for Oracle DBA on fundamental concepts. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides. |
| |
| Oracle DBA FAQ - Understanding SQL DDL Statements
Posted in Oracle > Miscellaneous by tutorialgrub on Apr 11, 2011
A collection of 12 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views. |
| |
| Oracle DBA FAQ - Creating New Database Instance Manually
Posted in Oracle > Miscellaneous by tutorialgrub on Apr 08, 2011
This is a collection of FAQ for Oracle DBA on creating Oracle database instances manually using CREATE DATABASE statement. Items in this FAQ collection are organized together to form a complete tutorial guide on creating a new database instance manually. |
| |
| Oracle 101
Posted in Oracle > Miscellaneous by tutorialgrub on Mar 31, 2011
An overview of Oracle illustrated with several examples. Content includes advanced techniques for database administration and PL-SQL programming. |
| |
| Expert One-on-One: Oracle: Part 2
Posted in Oracle > Miscellaneous by tutorialgrub on Mar 29, 2011
This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle. The second installment covers understanding Oracle architecture, using bind variables, understanding concurrency control, and multi-versioning. |
| |
| Expert One-on-One: Oracle: Part 4
Posted in Oracle > Miscellaneous by tutorialgrub on Mar 28, 2011
This fourth and final installment looks at making the database run faster and the DBA-developer relationship. This manuscript is Chapter 1 "Developing Successful Oracle Applications" from the Wrox Press book Expert One on One: Oracle. |
| |
| Rebuilding Oracle8 Object Types
Posted in Oracle > Miscellaneous by tutorialgrub on Mar 26, 2011
How can I rebuild an Oracle8 object type if it has table dependencies? Hey, that's a great question. Unfortunately, I haven't found a great answer. The basic problem is that Oracle offers two schema modification tools for object types, neither of which goes far enough. |
| |
| Advanced Replication
Posted in Oracle > Miscellaneous by tutorialgrub on Mar 26, 2011
Advanced replication allows the simultaneous transfer of data between two or more Master Sites. Each Master Site is fully functional and doesn't depend on pulling updates from a central site. The example below is a modified version of that found at Underground FAQs. In this example replication is setup between two Master Sites, TSH1 and TSH2, with the TSH1 instance as the Master Definition site, making it responsible for the coordination of the replication process. |
<< 1 2 3 4 |
