David Nishimoto

Contents Managing Datafiles Explain How to Manage Datafiles Creating Tablespaces Dimensions Explain the Structure and Maintenance of Tablespaces Creating Indexes Explain how to create an index Managing Rollback Segments Explain how manage a rollback segment Creating Snapshots Explain how to create an Oracle Snapshot Creating Tables Explain how to create a table Creating Constraints Primary […]

The following table walks you through the individual steps of the Database Assistant. After performing the task in each row, click the “Next” button in the Database Assistant to move to the next step. When done, click the “Finish” button. Click here for table.

set headsep–identifies a single character to split a title onto two or more lines ttitle–Top Title btitle–Bottom Title column–Heading and format of a column break on–Spaces between the section compute sum–Calculate subtotals set linesize–Set the maximum number of characters per line set pagesize–Set the number of lines per page set newpage–Set the number of lines […]

Create a Job VARIABLE v_jobnum NUMBER; BEGIN dbms_job.submit(:v_jobnum, ‘my_stored_procedure;’, sysdate,’sysdate+1′); END; Run an Existing Job dbms_job.run(job_number); Remove a Job from the Job Queue dbms_job.remove(job_number); Review Job Status select job, log_user, priv_user, schema_user, next_date, next_sec, interval, failures, total_time, what from dba_jobs; select * from user_jobs; select * from dba_jobs_running;

Click here for camparitive table.

Creating a Rollback Segment CREATE ROLLBACK SEGMENT {myRBS01} TABLESPACE {myrollback_tablespace} STORAGE ( INITIAL 100K NEXT 100K MINEXTENTS 20 MAXEXTENTS 121 ) Bringing a Rollback Segment Online alter rollback segment {myRBS01} online; rollback segments need to be entered into the init{sid}.ora file ROLLBACK_SEGMENTS=({myRBS01}) David Nishimoto For Listen Software

All About Logfiles Resetlogs option Immediately perform a complete consistent cold backup. Creates a new incarnation of the database, putting a new SCN in the headers of all database files Resets the log sequence number to 1 Reformats the online redo log files if they exists. Unintentionally Restoring Online Redo Logs When restoring a database, […]

Control File Backups [Editor’s note: the two code examples here are intended to each be written on one line; they’ve been line-wrapped here for formatting purposes.] Backup a Binary Version of the Control File ALTER DATABASE BACKUP CONTROLFILE TO ‘d:orantcontrol_backup’ Backup a Text Version of the Control File ALTER DATABASE BACKUP CONTROLFILE TO TRACE; David […]

See Also: Defining and Using Cursors Defining and Using Functions Stored Procedures Click here for commented script template. David Nishimoto For Listen Software

Overview Following the normalization guidelines usually means splitting tables into two or more tables with fewer columns. Primary and foreign key relationships are designed into the new smaller tables, so they can be reconnected with a join operation. The advantage of splitting the table is to reduce data redundancy. Here’s a brief guide to the […]