Label

Kamis, 07 September 2017

Import Database Oracle

export data user databse  dari database lama;
exp
user (username)
pass (password)

Sampai beres

install oracle database
setelah beres
dari command prompt
sqlplus /nolog
connect sys as sysdba
password (password)
create user (username) identified by (password);
grant dba to (username);

username dan password kita yang menentukan

dari command prompt
imp
masukan username dan password
pilih data export dari server lama
tunggu sampai beres

dari command prompt
sqlplus /nolog

connect (username)
password (password)
create user username identified by password;
grant create session to username;
create public synonym pzforlog for pzforlog;
grant select on pzforlog to username;
exit
connect sys as sysdba
password (password)
grant select on V_$SESSION TO (database);

Melawan lupa saat database tidak bisa terhubung dari user