Whoever Resembles a People is One of Them. He is not one of us who resembles other than us,
nor who resembles the Jews nor the Christians.(jami-at-tirmidhi-vol-5-ahadith-2695)
O you who believe (who wish to reach ALLAH C.C. before death)! Do not take my and
your enemies for friends!
And although they have denied what has come to you
from the Truth, you still love them (treating them as your friends).
If you go forth to struggle hard in My Way, seeking My Pleasure, (then why) you manifest
love to them and share with them your secrets.
And I know what you conceal and what you manifest. And whoever of you does that, then he
indeed has gone astray from the right Way. 60/Al-Mumtahanah-1
They are driving out the Messenger and yourselves from your land because you
believe in ALLAH C.C., your Lord.
Recite (read and explain to others) that which has been revealed to you of the Book
and keep up the Prayer.
Surely the Prayer keeps away from Al-Fahsh (to do what ALLAH C.C. prohibits) and Al-Munkar
(to deny what ALLAH C.C. commands).
Whoever obeys me, obeys ALLAH C.C., and whoever disobeys me, disobeys ALLAH C.C.
Whoever obeys the ruler, obeys me, and whoever disobeys the ruler, disobeys me. " (Sahih)

Import Adımları

Create TableSpace

CREATE TABLESPACE test_TBS DATAFILE
‘/u01/app/oracle/oradata/smp/test01.dbf’ SIZE 100M AUTOEXTEND ON NEXT 100M
MAXSIZE 1024M
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;

FLASHBACK ON 10G ve üzeri ise kullanılabilir.

Drop Tablespace


DROP TABLESPACE TestTBS INCLUDING CONTENTS AND DATAFILES;

Kullanıcı/Şema oluşturma
10G

CREATE USER testuser IDENTIFIED BY “testuser”
DEFAULT TABLESPACE deneme1
TEMPORARY TABLESPACE “TEMP”
QUOTA UNLIMITED ON deneme1;

9i

CREATE USER Mehmet IDENTIFIED BY “mehmet”
DEFAULT TABLESPACE TestTBS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TestTBS;

Kullanıcı Hakları
10G

GRANT “CONNECT” TO testuser;
GRANT “IMP_FULL_DATABASE” TO testuser;
GRANT “RESOURCE” TO testuser;
ALTER USER testuser DEFAULT ROLE NONE;
GRANT create session TO testuser;

9i

GRANT “CONNECT” TO Mehmet;
GRANT “IMP_FULL_DATABASE” TO Mehmet;
GRANT “RESOURCE” TO Mehmet;
ALTER USER Mehmet DEFAULT ROLE NONE;
GRANT create session TO Mehmet;

Imp

imp mehmet/mehmet file=/u01/ONDBA_15112006.dmp log=imp.log buffer=30000 touser=mehmet fromuser=ondba

Copyright © 2015 Sysdba All Rights Reserved Web Designer