ReliDB

Oracle provides several Configuration Assistant tools to facility administrative duties required by an Oracle DBA or Developer. The Oracle’s DBCA (Database Configuration Assistant) is the GUI tool used to create starter databases within the Oracle RDBMS. The DBCA utility was introduced in Oracle 8i and provides the user a GUI to eliminate the [...]

Posted on June 13th, 2010 under 11g, ASM, Oracle, Oracle 10g, hp-ux, itanium, linux, oracle 9i, unix. Tags: create, create database, database, dbca, make, Oracle, starting. Comments: None

Oracle provides database links to create direct connections from one database instance to another. This feature can come in handy in the movement of small to moderate amounts of data between systems. In this article we will review the creation of the DDL to regenerate public database links defined within an Oracle database.
1. [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, SQL, oracle 9i. Tags: create, database, dba_db_links, db_link, ddl, link, Oracle, recreate. Comments: None

Oracle uses Sequences to generate unique numbers to identify specific records. Once a sequence has been defined all a programmer or Oracle developer needs to obtain a unique key value for a record is to call the sequence. This article demonstrates how to generate the DDL for an already defined sequences in an [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, oracle 9i. Tags: create, ddl, generate, Oracle, recreate, sequence. Comments: None

Oracle uses Roles to define the privileges and rights a user has in an Oracle database. By defining a Role with specific system and object privileges, we greatly reduce the complexity of creating a new user account within any system. This is accomplished by assigning all specific rights to a single Role then [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, oracle 9i. Tags: create, ddl regenerate, Oracle, role, SQL. Comments: None

With the advent of Oracle 10g Import and Export data pump utility, the need to recreate a user account from scratch has been greatly reduced. However, there are still situation when you may need the SQL to recreate a specific user within another Oracle environment or just desire to see the creation statements. [...]

Posted on August 21st, 2009 under Oracle, Oracle 10g, RMAN, oracle 9i. Tags: create, Oracle, pl/sql, privileges, profile, recreate, role, SQL, sql to create user, user. Comments: None

Oracle provides the package DBMS_JOB(Pre 10g) and DBMS_SCHEDULER(Post 10g) to allow for the automation of pre-scheduled routine tasks in the Oracle database, just as they are performed by CRONTAB on UNIX and the Scheduler on Windows. This article will explain the use of DBMS_JOB and DBMS_SCHEDULER to take automatic snapshots for the STATSPACK utility [...]

Posted on August 7th, 2009 under Oracle. Tags: automated, create, dbms_jobs, dbms_scheduler, job, jobs, Oracle, scheduler, STATSPACK. Comments: None

Oracle provides views to allow you to hide the structures of under lying tables, to combine multiple tables into a single logical structure, and to reduce the complexity of SQL being generated against a database. Views allow the developer the flexibility to give users the look and feel of the database they desire, while [...]

Posted on July 20th, 2009 under Oracle, Oracle 10g, SQL, oracle 9i. Tags: create, Oracle, pl/sql, recreate, SQL, view. Comments: None

Oracle uses PROFILES to limit the access and resources a user has within an Oracle database. In a properly secured Oracle environment care must be taken in defining resource limits of your users. This article covers the creation of the DDL to define an Oracle profile already established in one database and recreate [...]

Posted on May 19th, 2009 under Oracle, Oracle 10g, SQL, oracle 9i. Tags: create, ddl, move, Oracle, profile, recreate. Comments: None