Sahabat

Archive for the ‘Database’ Category

import .dmp oracle di ubuntu (oracle 10g dan 11)

semua perintah imp,exp, dan sqlplus ada di folder

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

import :

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/imp username/password file=alamat.dmp full=y commit=y;

1	/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/imp username/password file=alamat.dmp full=y commit=y;

untuk oralce 11

/u01/app/oracle/product/11.2.0/xe/bin/imp sys/root@localhost/xe fromuser=xlink touser=xlink file=xlink_15_01_2013_rev2.dmp commit=y;

1	/u01/app/oracle/product/11.2.0/xe/bin/imp sys/root@localhost/xe fromuser=xlink touser=xlink file=xlink_15_01_2013_rev2.dmp commit=y;

Posted in Oracle

membuat function di mysql

create function dms_to_dec (d int,m float,s float,dir varchar(5)) returns float
    begin
    declare hasil float;
    declare hasil2 float;
    set hasil = round(d + (m/60) + (s/3600),8);
    if (UCASE(dir)='W' or UCASE(dir)='S') then
      set hasil2 = hasil*(-1);
    else
      set hasil2 = hasil;
    end if;
    return hasil2;
    end;

1

2

3

4

5

6

7

8

9

10

11

12

create function dms_to_dec (d int,m float,s float,dir varchar(5)) returns float

begin

declare hasil float;

declare hasil2 float;

set hasil = round(d + (m/60) + (s/3600),8);

if (UCASE(dir)='W' or UCASE(dir)='S') then

set hasil2 = hasil*(-1);

else

set hasil2 = hasil;

end if;

return hasil2;

end;

Posted in mysql

Buat user di oracle melalui sql*plus (ubuntu)

login sebagai admin (caranya).
buat user

CREATE user namauser identified by passworduser;

1

CREATE user namauser identified by passworduser;
Buat hak akses dari user

GRANT connect,resource,create view,create database link to namauser;

1

GRANT connect,resource,create view,create database link to namauser;

selesai.

(mohon koreksinya bila ada kesalahan)

Posted in Oracle

Koneksi ke oracle lewat sql*plus ubuntu

conn sys/root@localhost/XE as sysdba;

1	conn sys/root@localhost/XE as sysdba;

ket :

sys = username dari database
root = password dari database
localhost/XE = alamat database

(kalau ada salah mohon koreksinya yah)

Posted in Oracle