Oracle Applications Developer Vacancy

JUNIOR ORACLE DEVELOPER is REQUIRED for a large project in egypt .


1- JOB DESCRIPTION :

* CREATING APPLICATIONS TO MANAGE A STARTER DATABASE FOR AN EDUCATIONAL INSTITUTE .

-------------------------

2- QUALIFICATIONS :

* Oracle 10g r2 OCP DEVELOPER

* FRESH GRADUATE ( Bachelor Degree or EQUAL)

* V. GOOD COMMAND OF ENGLISH

-------------------------

3- CONTACT :

Send resume to : admin.ahmedabdelgwad@gmail.com

Incremental Backup

Incremental Level 0 : Is Considered To Be An Image Copy Of The DataBase .

i.e: Contains All Used Data Blocks .

Incremental Level 1 : Contains Only Modified Blocks Since The Last Level 0 Incremental Backup .

Logical Things :

Any Administrator May Consider That Incremental Level 0 Backup Is Conducted First , Followed By Level 1 Backup .

EXAMPLE:

Saturday:

Rman> Backup Incremental Level 0 Database ;

Monday:

Rman> Backup Incremental Level 1 Database ;

and etc......

EXTERNAL TABLES

An external table is a database file or even a text file on local disk which MUST BE :

1- column types in excel or word files match column types of the database table .

i.e: if first column in database table is NUMBER , first column in excel file should be NUMBER TOO !


2- character length must match too .

i.e: if first column in database table is NAME and accepts only 4 characters to be inserted , first column in excel file is NAME and contains value 'Ahmed' which is 5 characters length ... this causes an error when you try to select data from external table.


3- READ , WRITE on directory .. these privileges must be granted to user creating an external table.

-- EXTERNAL TABLES ARE USEFUL TO IMPORT YOUR MS EXCEL FILES OR DATA STORED IN ANY FILE TO YOUR DATABASE !!

EXAMPLE :

CREATE TABLE TEST1
(TEST NUMBER(3) , NAME VARCHAR2(25), LOCATION VARCHAR2(25))

ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER
DEFAULT DIRECTORY MYDIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY newline
NOLOGFILE
NOBADFILE
FIELDS TERMINATED BY ',' )
LOCATION ( 'TEXTFILE.TXT)) ;

EASY !!

Nigerian Scammers Target UNFPA !

THIS IS A SCREEN SHOT of the email i recieved ,

this user is claiming to be one of the UNFPA Team members , and claiming that i won 1.850.000.00 Dollars !

BUT HE DON`T EVEN KNOW MY NAME !

AIM of these e-mails:

when somebody responds and asks to claim his dollars , the Nigerian scammer asks for a valid bank account number to send the money to .

then he sends a first small transfer to check the account validity .. now the victim thinks he really won !

the scammer asks the victim to re-send this money to him , so he can send his big reward !!

and ... BLOW !

now the scammer had money from a stolen bank account , by transfering to the victim`s account , the victim sent him CLEAN MONEY !

BEWARE OF SUCH ATTACKS , You Will Be Responsible For Stealing Money From The Other Victim , Until You Prove You Were A Victim Too !

Oracle DataBase BackUp

DATABASE BACKUP

BackUp: Server Managed Backup & User Managed Backup .

Steps to backup your oracle database:

1- Enable Archive Logging ( SqlPlus:> Alter Database Archivelog ; )

2- Create Rman Target / Catalog .

Target: System/password@database

Catalog: Rman/password@database

Where : Rman is a user name which was granted Recovery_Catalog_Owner Role .

3- Enable Control File Auto Backup ( Rman> Configure ControlFile Autobackup on )

4-

Rman> Target system/password@database Catalog Rman/password@database

Rman> Create catalog tablespace Rman

Rman> Register database

5- Backup your database

Rman> Backup Incremental Level 0 Database

-----------------------------------------

Run Games Faster On A Slow Computer

Your Computer Is Slow For Playing Games ?

1- ALT + CTRL + DELETE --> Task Manager --> End Task For All Applications running under your user name .

LEAVE Running: TASKMGR .exe , CTFMON.EXE ,EXPLORER.exe .


2- GoTo START --> RUN --> dxdiag --> click ok .

Choose SOUND from top bar of window , HARDWARE SOUND ACCELERATION LEVEL = BASIC .

3- IF you are using HIGH Resolution in Game Setting , Try To Decrease it .. this improves performance of your computer .

4- RUN YOUR GAME !

This Blog Ranked #17 (Security Site) At TopOfBlogs.com !