Search the web
Sign In
New User? Sign Up
indo-oracle · Indonesia Oracle User Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 22014 - 22043 of 22043   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#22043 From: Wadi Achmed <wadiachmed@...>
Date: Thu Nov 26, 2009 3:09 pm
Subject: Re: Tentang Hasil di CMD ....
wadiachmed
Online Now Online Now
Send Email Send Email
 
Hi,

Asumsi panjang karakter di screen command prompt windows 80char, maka
di sqlplus nya eksekusi dulu command berikut
SQL> column KODE_SUPPLIER format a5
SQL> column NAMA_SUPPLIER format a20
SQL> column ALAMAT_SUPPLIER format a25
SQL> column KOTA_SUPPLIER format a15
SQL> column TELEPON_SUPPLIER format a15
SQL> select * from supplier;

nah hasilnya mudah2an sesuai dengan yang diharapkan.
Cheers,
Wadi Achmed

Mx7 wrote:
> Mau nanya lagi :
>
> saya dah buat table supplier :
>
> -- 2. TABLE SUPPLIER
> insert into supplier values('EJ-01', 'PT.Actron', 'Jl. Thamrin 12', 'Jakarta',
'(021)-850-2301');
> insert into supplier values('EJ-02', 'PT Mulya Elektronik', 'Jl Sudirman 45',
'Jakarta', '(021)-855-4264');
> insert into supplier values('EB-01', 'PT Ultrasound', 'Jl Sukarno Hatta 103',
'Bandung', '(022)-522-3305');
> insert into supplier values('EB-02', 'PT Supertron', 'Jl Industri 37',
'Bandung', '(022)-660-4091');
>
> Hasil yang keluar di cmd :
> SQL> select * from supplier;
>
> KODE_ NAMA_SUPPLIER                  ALAMAT_SUPPLIER
> ----- ------------------------------ ------------------------------
> KOTA_SUPPLIER   TELEPON_SUPPLIER
> --------------- -------------------------------
> EJ-01 PT.Actron                      Jl. Thamrin 12
> Jakarta         (021)-850-2301
>
> EJ-02 PT Mulya Elektronik            Jl Sudirman 45
> Jakarta         (021)-855-4264
>
> EB-01 PT Ultrasound                  Jl Sukarno Hatta 103
> Bandung         (022)-522-3305
>
> Pertanyaannya :
> gimana caranya di cmd biar hasil yang keluar seperti ini :
> KODE_SUPPLIER    NAMA_SUPPLIER  ALAMAT_SUPPLIER  KOTA_SUPPLIER  
TELEPON_SUPPLIER
> ---------------------   ---------------------   -----------------------  
--------------------  -------------------------
> blablabalbla
> blablabal
> balbalbal
>
> maksudnya, hasilnya biar ga kepotong terus jadi kebawah, saya pengennya tampil
kepinggir & rapih seperti itu ...
> 1. apa ada caranya biar hasilnya lebih enak dilihat seperti itu? settingan di
cmd?
> 2. selain pake cmd, apakah ada cara lain untuk mengcompile & menampilkan hasil
dari kode2 tersebut? cmd yang saya pake sekarang dari :
D:\app\Owner\product\11.1.0\db_1\BIN\sqlplus.exe
> soalnya saya melakukan insert dll pake TextPad, tapi untuk menampilkan masih
tetep pake cmd spt yang diatas....
>
> mohon bimbingannya ...
> terima kasih banyak ....
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: indo-oracle-unsubscribe@yahoogroups.com
> Website: http://indooracle.wordpress.com
> http://www.facebook.com/group.php?gid=51973053515
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.comYahoo! Groups Links
>
>
>
>
>


[Non-text portions of this message have been removed]

#22042 From: Mx7 <iqbal_gamers@...>
Date: Thu Nov 26, 2009 11:25 am
Subject: Ga Bisa Connect Lagi >..
iqbal_gamers
Offline Offline
Send Email Send Email
 
@ALL ...

Thx banget dah mau bantuin ...

aku coba dulu saran dari temen2 semua biar bisa connect ke db lagi ....

thx again ...
ntar kalo ada problem lagi, aku nanya lagi hehehe ...





[Non-text portions of this message have been removed]

#22041 From: Mx7 <iqbal_gamers@...>
Date: Thu Nov 26, 2009 12:57 pm
Subject: Tentang Hasil di CMD ....
iqbal_gamers
Offline Offline
Send Email Send Email
 
Mau nanya lagi :

saya dah buat table supplier :

-- 2. TABLE SUPPLIER
insert into supplier values('EJ-01', 'PT.Actron', 'Jl. Thamrin 12', 'Jakarta',
'(021)-850-2301');
insert into supplier values('EJ-02', 'PT Mulya Elektronik', 'Jl Sudirman 45',
'Jakarta', '(021)-855-4264');
insert into supplier values('EB-01', 'PT Ultrasound', 'Jl Sukarno Hatta 103',
'Bandung', '(022)-522-3305');
insert into supplier values('EB-02', 'PT Supertron', 'Jl Industri 37',
'Bandung', '(022)-660-4091');

Hasil yang keluar di cmd :
SQL> select * from supplier;

KODE_ NAMA_SUPPLIER                  ALAMAT_SUPPLIER
----- ------------------------------ ------------------------------
KOTA_SUPPLIER   TELEPON_SUPPLIER
--------------- -------------------------------
EJ-01 PT.Actron                      Jl. Thamrin 12
Jakarta         (021)-850-2301

EJ-02 PT Mulya Elektronik            Jl Sudirman 45
Jakarta         (021)-855-4264

EB-01 PT Ultrasound                  Jl Sukarno Hatta 103
Bandung         (022)-522-3305

Pertanyaannya :
gimana caranya di cmd biar hasil yang keluar seperti ini :
KODE_SUPPLIER    NAMA_SUPPLIER  ALAMAT_SUPPLIER  KOTA_SUPPLIER  
TELEPON_SUPPLIER
---------------------   ---------------------   -----------------------  
--------------------  -------------------------
blablabalbla
blablabal
balbalbal

maksudnya, hasilnya biar ga kepotong terus jadi kebawah, saya pengennya tampil
kepinggir & rapih seperti itu ...
1. apa ada caranya biar hasilnya lebih enak dilihat seperti itu? settingan di
cmd?
2. selain pake cmd, apakah ada cara lain untuk mengcompile & menampilkan hasil
dari kode2 tersebut? cmd yang saya pake sekarang dari :
D:\app\Owner\product\11.1.0\db_1\BIN\sqlplus.exe
soalnya saya melakukan insert dll pake TextPad, tapi untuk menampilkan masih
tetep pake cmd spt yang diatas....

mohon bimbingannya ...
terima kasih banyak ....





[Non-text portions of this message have been removed]

#22040 From: "yanaora" <yanaora@...>
Date: Thu Nov 26, 2009 1:11 pm
Subject: Re: Tanya Cek Jika Record Ada Pake Trigger
yanaora
Offline Offline
Send Email Send Email
 
@Agus Haryanto
Makasih mas atas responsnya

Iya aku ingin trigger ini menginsert/update ke table itu sendiri. kebetulan aku
sering insert manual pake SQL Statement kadang suka lupa kalau ada beberapa
record yang sama dengan yang akan dimasukkan, sudah dimasukkan sebelumnya. BTW
makasih banyak pak agus atas sharingnya yang sangat bermanfaat. ta cobain pake
SP yang pa agus contohkan

--- In indo-oracle@yahoogroups.com, Agus Haryanto <agus_h23@...> wrote:
>
> Pertanyaanya ini.
>
> Menginsert dan mengupdate ketable itu sendiri atau ke table lain.
>
> kalau ke table itu sendiri TRIGGER tidak bisa (akan terjadi error mutating)
>
> Untuk Hal ini sebaiknya gunakan Store Procedure Pak
>
> algoritmanya
>
> Lakukan perintah Update dulu
> jika row yang terupdate hasilnya = 0
> lakukan perintah insert
>
>
>
>
>
>
>
>
> ________________________________
> From: yanaora <yanaora@...>
> To: indo-oracle@yahoogroups.com
> Sent: Thu, 26 November, 2009 10:01:12
> Subject: [indo-oracle] Tanya Cek Jika Record Ada Pake Trigger
>
>
> Dear All
>
> Aku mau tanya bagaimana caranya menggunakan TRIGGER BEFORE/AFTER INSERT supaya
ketika ada statement INSERT ke dalam table dengan "record key" yang sama yang
sudah ada didalam table maka record yang baru tersebut akan meng-UPDATE record
lama (jika ada) sedangkan jika belum ada maka proses INSERT akan terjadi seperti
biasa
>
> terima kasih sebelumnya
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

#22039 From: wisnu dwi hidayat <wisnu_dh@...>
Date: Thu Nov 26, 2009 9:26 am
Subject: Configure Enterprise Manager
wisnu_dh
Online Now Online Now
Send Email Send Email
 
Dear Masters & Members,

Saya dapet kendala nih saat sedang create Enterprise Manager Oracle di Server
Development saya;
Padahal waktu saya buat production gak rumit seperti sekarang.. ada aja
errornya..

Berikut yg saya lakukan..

[oracle@development db_1]$ cd $ORACLE_HOME/bin

[oracle@development bin]$ ./emca -config dbcontrol db -repos create

STARTED EMCA at Nov 26, 2009 3:21:48 PM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: PROD
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): admin@...
Outgoing Mail (SMTP) server for notifications (optional): disamarkan
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /OraHome/oracle11g/product/11.1.0/db_1

Local hostname ................ development
Listener port number ................ 1521
Database SID ................ PROD
Email address for notifications ............... admin@...
Outgoing Mail (SMTP) server for notifications ............... disamarkan

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 26, 2009 3:23:01 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_26_15_21_48.log.
Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_repos_create_<date>.log for more
details.
Nov 26, 2009 3:23:02 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_26_15_21_48.log for more
details.
Could not complete the configuration. Refer to the log file at
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_21_48.log for more
details.

Nah dalam log tersebut saya mendapati salah satu kejanggalan
Could not connect to
SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=development)(PORT=15\
21)))(CONNECT_DATA=(SERVICE_NAME=PROD))): ORA-01031: insufficient privileges
(DBD ERROR: OCISessionBegin)

Saya sudah googling dan saya coba beberapa saran dan saya malah dapat error
demikian

Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Enter SYS user's password :
Getting temporary tablespace from database...
Could not connect to
SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=development)(PORT=15\
21)))(CONNECT_DATA=(SERVICE_NAME=PROD))): ORA-01031: insufficient privileges
(DBD ERROR: OCISessionBegin)

Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: stty: standard input: Invalid argument
stty: standard input: Invalid argument

Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing
/OraHome/oracle11g/product/11.1.0/db_1/sysman/admin/emdrep/bin/RepManager
-connect
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=development)(PORT=1521))\
)(CONNECT_DATA=(SERVICE_NAME=PROD))) -repos_user SYSMAN -action drop -verbose
-output_file
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_repos_drop_2009_11_26_15_34_27.log
Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_repos_drop_<date>.log for more
details.
Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at
/OraHome/oracle11g/cfgtoollogs/emca/PROD/emca_2009_11_26_15_34_05.log for more
details.
Nov 26, 2009 3:34:27 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:208)
         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:221)
         at
oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:534)
      
atoracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.ja\
va:1214)
         at
oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:518)
         at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:467)


Mohon bantuan dari Masters dan Members skalian..

Regards,
Wisnu




[Non-text portions of this message have been removed]

#22038 From: "yulius_wibowo" <yulius_wibowo@...>
Date: Thu Nov 26, 2009 9:25 am
Subject: Re: EXPORT dengan perintah EXPDP
yulius_wibowo
Offline Offline
Send Email Send Email
 
SGA_TARGET nya diset seberapa besar?

bw

--- In indo-oracle@yahoogroups.com, "obie_xp" <obie_xp@...> wrote:
>
> Terima kasih pak yulius. saya sudah membuat logical Directory seperti yang
bapak minta. dengan perintah sebagai berikut:
> CREATE OR REPLACE DIRECTORY backup AS '/dbop'  ;
> GRANT IMP_FULL_DATABASE TO OBIE_DATA;
> GRANT EXP_FULL_DATABASE TO OBIE_DATA;
> grant read,write on directory backup to OBIE_DATA;
>
> lalu saya coba cek di DBA_DIRECTORIES:
>
> SELECT * FROM DBA_DIRECTORIES.
>
> Kemudian saya ulangi perintah backup tadi :
>
> expdp OBIE_DATA/xxxxx DIRECTORY=backup DUMPFILE=rpm_backup231109.dmp
LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3)
>
> Tetapi masih terdapat error :
>
> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
64bit Production
> With the Partitioning, OLAP and Data Mining options
> ORA-31626: job does not exist
> ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user RMS13DEV
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPV$FT_INT", line 600
> ORA-39080: failed to create queues "KUPC$C_1_20091126153947" and
"KUPC$S_1_20091126153947" for Data Pump job
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
> ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")
>
> Mohon Petunjuk lagi.
>
> Regards,
> OBIE
>
> --- In indo-oracle@yahoogroups.com, "yulius_wibowo" <yulius_wibowo@> wrote:
> >
> >
> > Coba pastikan nilai utk opsi directory sudah sesuai dgn informasi yg ada di
DBA_DIRECTORIES. Perlu dicatat nilai DIRECTORY bukanlah PHYSICAL directory
melainkan LOGICAL directory yg didefinisikan menggunakan CREATE DIRECTORY.
> >
> > cmiiw,
> > Bowo
> >
> >
> > --- In indo-oracle@yahoogroups.com, "obie_xp" <obie_xp@> wrote:
> > >
> > > Teman2 master oracle saya ingin bertanya tentang masalah yang saya hadapi
saat melakukan export database dengan perintah EXPDP
> > >
> > > expdp OBIE_DATA/xxxxx DIRECTORY=/dbop/backup DUMPFILE=rpm_backup231109.dmp
LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3)
> > >
> > > Terdapat eror seperti dibawah ini :
> > > Copyright (c) 2003, 2005, Oracle.  All rights reserved.
> > >
> > > Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
64bit Production
> > > With the Partitioning, OLAP and Data Mining options
> > > ORA-31626: job does not exist
> > > ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user OBIE_DATA
> > > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> > > ORA-06512: at "SYS.KUPV$FT_INT", line 600
> > > ORA-39080: failed to create queues "KUPC$C_1_20091126094544" and
"KUPC$S_1_20091126094544" for Data Pump job
> > > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> > > ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
> > > ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")
> > >
> > > Apakah ada konfigurasi yang belum dilakukan terhadap user OBIE_DATA?
> > >
> > > Mohon Petunjuknya.
> > >
> > > Regards,
> > > OBIE
> > >
> >
>

#22037 From: Agus Haryanto <agus_h23@...>
Date: Thu Nov 26, 2009 9:17 am
Subject: Re: Tanya Cek Jika Record Ada Pake Trigger
agus_h23
Offline Offline
Send Email Send Email
 
Pertanyaanya ini.

Menginsert dan mengupdate ketable itu sendiri atau ke table lain.

kalau ke table itu sendiri TRIGGER tidak bisa (akan terjadi error mutating)

Untuk Hal ini sebaiknya gunakan Store Procedure Pak

algoritmanya

Lakukan perintah Update dulu
jika row yang terupdate hasilnya = 0
lakukan perintah insert








________________________________
From: yanaora <yanaora@...>
To: indo-oracle@yahoogroups.com
Sent: Thu, 26 November, 2009 10:01:12
Subject: [indo-oracle] Tanya Cek Jika Record Ada Pake Trigger


Dear All

Aku mau tanya bagaimana caranya menggunakan TRIGGER BEFORE/AFTER INSERT supaya
ketika ada statement INSERT ke dalam table dengan "record key" yang sama yang
sudah ada didalam table maka record yang baru tersebut akan meng-UPDATE record
lama (jika ada) sedangkan jika belum ada maka proses INSERT akan terjadi seperti
biasa

terima kasih sebelumnya







[Non-text portions of this message have been removed]

#22036 From: Erry Pambudhi <erry_pambudhi@...>
Date: Thu Nov 26, 2009 9:12 am
Subject: Bls: Re: WTA: how to set datetime (now) in text item @ oracle form
erry_pambudhi
Offline Offline
Send Email Send Email
 
kalo mau gitu text itemnya di set varchar aja... baru select to_char .... into
:tgl_jual

cheers..


Erry

--- Pada Kam, 26/11/09, Ruben Edson <reps_it@...> menulis:

Dari: Ruben Edson <reps_it@...>
Judul: [indo-oracle] Re: WTA: how to set datetime (now) in text item @ oracle
form
Kepada: indo-oracle@yahoogroups.com
Tanggal: Kamis, 26 November, 2009, 3:38 AM







 









       Thank's Ibu  Marina dan Bapak Murdi...



btw, klo utk menampilkan waktunya (jam, menit dan detik) jg, gmn?



____________ _________ _________ __

From: marina <marina.christien@ gmail.com>

To: indo-oracle@ yahoogroups. com

Sent: Thu, November 26, 2009 2:38:53 PM

Subject: Re: [indo-oracle] WTA: how to set datetime (now) in text item @ oracle
form



Pak Ruben,

kalau mau format tanggl yg panjang langsung saja gunakan tipe data

datetime terus gak usah di kasi to_char.

contoh :tgl_jual := sysdate;

kalau mau menggunakan to_char ya tipe text itemnya haru char juga.



semoga berhasil.



Ruben Edson wrote:

>

>

> Dear: All user indo-oracle

>

> bagaimana cara setting waktu di text item (:penjualan. tgl_jual) ketika

> form pertama kali running?

>

> berikut ini codingnya:

> saya buat trigger (When-New-Form Instance) di form

> begin

> select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into

> :penjualan.tgl_ jual from dual;

> end;

>

> dengan format field tgl_jual date, muncul error...

>

> mohon saran / masukan temans... Thanks a lot :D

>

> [Non-text portions of this message have been removed]

>

>



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]























       Selalu bersama teman-teman di Yahoo! Messenger. Tambahkan mereka dari
email atau jaringan sosial Anda sekarang! http://id.messenger.yahoo.com/invite/

[Non-text portions of this message have been removed]

#22035 From: "obie_xp" <obie_xp@...>
Date: Thu Nov 26, 2009 8:50 am
Subject: Re: EXPORT dengan perintah EXPDP
obie_xp
Offline Offline
Send Email Send Email
 
Terima kasih pak yulius. saya sudah membuat logical Directory seperti yang bapak
minta. dengan perintah sebagai berikut:
CREATE OR REPLACE DIRECTORY backup AS '/dbop'  ;
GRANT IMP_FULL_DATABASE TO OBIE_DATA;
GRANT EXP_FULL_DATABASE TO OBIE_DATA;
grant read,write on directory backup to OBIE_DATA;

lalu saya coba cek di DBA_DIRECTORIES:

SELECT * FROM DBA_DIRECTORIES.

Kemudian saya ulangi perintah backup tadi :

expdp OBIE_DATA/xxxxx DIRECTORY=backup DUMPFILE=rpm_backup231109.dmp
LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3)

Tetapi masih terdapat error :

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user RMS13DEV
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20091126153947" and
"KUPC$S_1_20091126153947" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")

Mohon Petunjuk lagi.

Regards,
OBIE

--- In indo-oracle@yahoogroups.com, "yulius_wibowo" <yulius_wibowo@...> wrote:
>
>
> Coba pastikan nilai utk opsi directory sudah sesuai dgn informasi yg ada di
DBA_DIRECTORIES. Perlu dicatat nilai DIRECTORY bukanlah PHYSICAL directory
melainkan LOGICAL directory yg didefinisikan menggunakan CREATE DIRECTORY.
>
> cmiiw,
> Bowo
>
>
> --- In indo-oracle@yahoogroups.com, "obie_xp" <obie_xp@> wrote:
> >
> > Teman2 master oracle saya ingin bertanya tentang masalah yang saya hadapi
saat melakukan export database dengan perintah EXPDP
> >
> > expdp OBIE_DATA/xxxxx DIRECTORY=/dbop/backup DUMPFILE=rpm_backup231109.dmp
LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3)
> >
> > Terdapat eror seperti dibawah ini :
> > Copyright (c) 2003, 2005, Oracle.  All rights reserved.
> >
> > Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
64bit Production
> > With the Partitioning, OLAP and Data Mining options
> > ORA-31626: job does not exist
> > ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user OBIE_DATA
> > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> > ORA-06512: at "SYS.KUPV$FT_INT", line 600
> > ORA-39080: failed to create queues "KUPC$C_1_20091126094544" and
"KUPC$S_1_20091126094544" for Data Pump job
> > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> > ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
> > ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")
> >
> > Apakah ada konfigurasi yang belum dilakukan terhadap user OBIE_DATA?
> >
> > Mohon Petunjuknya.
> >
> > Regards,
> > OBIE
> >
>

#22034 From: Ruben Edson <reps_it@...>
Date: Thu Nov 26, 2009 8:38 am
Subject: Re: WTA: how to set datetime (now) in text item @ oracle form
reps_it
Offline Offline
Send Email Send Email
 
Thank's Ibu  Marina dan Bapak Murdi...

btw, klo utk menampilkan waktunya (jam, menit dan detik) jg, gmn?




________________________________
From: marina <marina.christien@...>
To: indo-oracle@yahoogroups.com
Sent: Thu, November 26, 2009 2:38:53 PM
Subject: Re: [indo-oracle] WTA: how to set datetime (now) in text item @ oracle
form


Pak Ruben,
kalau mau format tanggl yg panjang langsung saja gunakan tipe data
datetime terus gak usah di kasi to_char.
contoh :tgl_jual := sysdate;
kalau mau menggunakan to_char ya tipe text itemnya haru char juga.

semoga berhasil.

Ruben Edson wrote:
>
>
> Dear: All user indo-oracle
>
> bagaimana cara setting waktu di text item (:penjualan. tgl_jual) ketika
> form pertama kali running?
>
> berikut ini codingnya:
> saya buat trigger (When-New-Form Instance) di form
> begin
> select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into
> :penjualan.tgl_ jual from dual;
> end;
>
> dengan format field tgl_jual date, muncul error...
>
> mohon saran / masukan temans... Thanks a lot :D
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

#22033 From: murdi santoso <sandi_ui@...>
Date: Thu Nov 26, 2009 7:42 am
Subject: Re: WTA: how to set datetime (now) in text item @ oracle form
sandi_ui
Offline Offline
Send Email Send Email
 
errornya apa mas..?

mungkin datatype untuk item :penjualan.tgl_ jualmasih dalam format date. kalau
diganti ke varchar mungkin bisa.









________________________________
From: Ruben Edson <reps_it@...>
To: indo-oracle@yahoogroups.com
Sent: Thu, November 26, 2009 2:25:28 PM
Subject: [indo-oracle] WTA: how to set datetime (now) in text item @ oracle form


Dear: All user indo-oracle

bagaimana cara setting waktu di text item (:penjualan. tgl_jual) ketika form
pertama kali running?

berikut ini codingnya:
saya buat trigger (When-New-Form Instance) di form
begin
select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into  :penjualan.tgl_ jual
from dual;
end;

dengan format field tgl_jual date, muncul error...

mohon saran / masukan temans... Thanks a lot :D

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

#22032 From: marina <marina.christien@...>
Date: Thu Nov 26, 2009 7:38 am
Subject: Re: WTA: how to set datetime (now) in text item @ oracle form
marina.christien@...
Send Email Send Email
 
Pak Ruben,
kalau mau format tanggl yg panjang langsung saja gunakan tipe data
datetime terus gak usah di kasi to_char.
contoh :tgl_jual := sysdate;
kalau mau menggunakan to_char ya tipe text itemnya haru char juga.

semoga berhasil.

Ruben Edson wrote:
>
>
> Dear: All user indo-oracle
>
> bagaimana cara setting waktu di text item (:penjualan.tgl_jual) ketika
> form pertama kali running?
>
> berikut ini codingnya:
> saya buat trigger (When-New-Form Instance) di form
> begin
> select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into
> :penjualan.tgl_jual from dual;
> end;
>
> dengan format field tgl_jual date, muncul error...
>
> mohon saran / masukan temans... Thanks a lot :D
>
> [Non-text portions of this message have been removed]
>
>



[Non-text portions of this message have been removed]

#22031 From: Ruben Edson <reps_it@...>
Date: Thu Nov 26, 2009 7:25 am
Subject: WTA: how to set datetime (now) in text item @ oracle form
reps_it
Offline Offline
Send Email Send Email
 
Dear: All user indo-oracle

bagaimana cara setting waktu di text item (:penjualan.tgl_jual) ketika form
pertama kali running?

berikut ini codingnya:
saya buat trigger (When-New-Form Instance) di form
begin
         select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into 
:penjualan.tgl_jual from dual;
end;

dengan format field tgl_jual date, muncul error...

mohon saran / masukan temans... Thanks a lot :D





[Non-text portions of this message have been removed]

#22030 From: "yulius_wibowo" <yulius_wibowo@...>
Date: Thu Nov 26, 2009 6:53 am
Subject: Re: EXPORT dengan perintah EXPDP
yulius_wibowo
Offline Offline
Send Email Send Email
 
Coba pastikan nilai utk opsi directory sudah sesuai dgn informasi yg ada di
DBA_DIRECTORIES. Perlu dicatat nilai DIRECTORY bukanlah PHYSICAL directory
melainkan LOGICAL directory yg didefinisikan menggunakan CREATE DIRECTORY.

cmiiw,
Bowo


--- In indo-oracle@yahoogroups.com, "obie_xp" <obie_xp@...> wrote:
>
> Teman2 master oracle saya ingin bertanya tentang masalah yang saya hadapi saat
melakukan export database dengan perintah EXPDP
>
> expdp OBIE_DATA/xxxxx DIRECTORY=/dbop/backup DUMPFILE=rpm_backup231109.dmp
LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3)
>
> Terdapat eror seperti dibawah ini :
> Copyright (c) 2003, 2005, Oracle.  All rights reserved.
>
> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
64bit Production
> With the Partitioning, OLAP and Data Mining options
> ORA-31626: job does not exist
> ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user OBIE_DATA
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPV$FT_INT", line 600
> ORA-39080: failed to create queues "KUPC$C_1_20091126094544" and
"KUPC$S_1_20091126094544" for Data Pump job
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
> ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")
>
> Apakah ada konfigurasi yang belum dilakukan terhadap user OBIE_DATA?
>
> Mohon Petunjuknya.
>
> Regards,
> OBIE
>

#22029 From: Henri Alia Putra <henriap@...>
Date: Thu Nov 26, 2009 5:01 am
Subject: RE: Ga bisa connect lagi !!!
henriap@...
Send Email Send Email
 
Coba cek di sqlnet.ora, coba di tutup autentication ....



From: indo-oracle@yahoogroups.com [indo-oracle@yahoogroups.com] On Behalf Of
easy nation [easynation@...]
Sent: Wednesday, November 25, 2009 9:49 PM
To: indo-oracle@yahoogroups.com
Subject: Bls: [indo-oracle] Ga bisa connect lagi !!!



coba di-set sid mas...

set oracle_sid=<namaSID>

trus coba login lagi.

--- Pada Rab, 25/11/09, Mx7 <iqbal_gamers@...> menulis:

Dari: Mx7 <iqbal_gamers@...>
Judul: [indo-oracle] Ga bisa connect lagi !!!
Kepada: indo-oracle@yahoogroups.com
Tanggal: Rabu, 25 November, 2009, 8:31 AM



Met kenal semuanya ...

saia baru banget belajar ORACLE & yang pasti ada masalah tentang Oracle ...
masalahnya gini :

Hari pertama ... saia dah berhasil install .. trus berhasil juga connect pake
cara :

sqlpuls / nolog

SQL> connect mizzu/mizzu as sysdba

dan langsung connect ...

buat table awal juga berhasil...

Hari kedua & seterusnya ... tiba2 ga bisa connect, dah coba semua service di
Oracle di aktifkan (service.msc) , listener juga dah jalan, tapi tetep ga bisa
connect ...

berikut hasil yang di cmd :

C:\Documents and Settings\Owner> sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 25 08:24:56 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> connect mizzu/mizzu as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

Tolong ... saia harus gimana lagi biar bisa connect ....

mohon bimbingannya ....

thx ..

[Non-text portions of this message have been removed]

Lebih Bersih, Lebih Baik, Lebih Cepat - Rasakan Yahoo! Mail baru yang Lebih
Cepat hari ini! http://id.mail.yahoo.com

[Non-text portions of this message have been removed]




This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email by mistake please notify the sender by return
e-mail and delete this message from your system. Any unauthorized use or
dissemination of this e-mail in whole or in part is strictly prohibited. PT
Federal International Finance, which has its seat at North of Jakarta,
Indonesia, including its affiliated companies, shall not be liable for the
improper or incomplete transmission of the information contained in this e-mail
nor for any delay in its receipt or damage to your system. PT Federal
International Finance (or its affiliated companies) does not guarantee that the
integrity of this communication has been maintained nor that this communication
is free of viruses, interceptions or interference.

#22028 From: "obie_xp" <obie_xp@...>
Date: Thu Nov 26, 2009 3:14 am
Subject: EXPORT dengan perintah EXPDP
obie_xp
Offline Offline
Send Email Send Email
 
Teman2 master oracle saya ingin bertanya tentang masalah yang saya hadapi saat
melakukan export database dengan perintah EXPDP

expdp OBIE_DATA/xxxxx DIRECTORY=/dbop/backup DUMPFILE=rpm_backup231109.dmp
LOGFILE=rpm_backup231109.log tables=(Table1,Table2,Table3)

Terdapat eror seperti dibawah ini :
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user OBIE_DATA
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20091126094544" and
"KUPC$S_1_20091126094544" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")

Apakah ada konfigurasi yang belum dilakukan terhadap user OBIE_DATA?

Mohon Petunjuknya.

Regards,
OBIE

#22027 From: easy nation <easynation@...>
Date: Wed Nov 25, 2009 2:49 pm
Subject: Bls: Ga bisa connect lagi !!!
easynation
Offline Offline
Send Email Send Email
 
coba di-set sid mas...

set oracle_sid=<namaSID>

trus coba login lagi.

--- Pada Rab, 25/11/09, Mx7 <iqbal_gamers@...> menulis:

Dari: Mx7 <iqbal_gamers@...>
Judul: [indo-oracle] Ga bisa connect lagi !!!
Kepada: indo-oracle@yahoogroups.com
Tanggal: Rabu, 25 November, 2009, 8:31 AM







 









       Met kenal semuanya ...

saia baru banget belajar ORACLE & yang pasti ada masalah tentang Oracle ...
masalahnya gini :

Hari pertama ... saia dah berhasil install .. trus berhasil juga connect pake
cara :



sqlpuls / nolog

SQL> connect mizzu/mizzu as sysdba



dan langsung connect ...

buat table awal juga berhasil...



Hari kedua & seterusnya  ... tiba2 ga bisa connect, dah coba semua service di
Oracle di aktifkan (service.msc) , listener juga dah jalan, tapi tetep ga bisa
connect ...



berikut hasil yang di cmd :



C:\Documents and Settings\Owner> sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 25 08:24:56 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.



SQL> connect mizzu/mizzu as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error



Tolong ... saia harus gimana lagi biar bisa connect ....

mohon bimbingannya ....

thx ..



[Non-text portions of this message have been removed]























       Lebih Bersih, Lebih Baik, Lebih Cepat - Rasakan Yahoo! Mail baru yang
Lebih Cepat hari ini! http://id.mail.yahoo.com

[Non-text portions of this message have been removed]

#22026 From: "yanaora" <yanaora@...>
Date: Thu Nov 26, 2009 3:01 am
Subject: Tanya Cek Jika Record Ada Pake Trigger
yanaora
Offline Offline
Send Email Send Email
 
Dear All

Aku mau tanya bagaimana caranya menggunakan TRIGGER BEFORE/AFTER INSERT supaya
ketika ada statement INSERT ke dalam table dengan "record key" yang sama yang
sudah ada didalam table maka record yang baru tersebut akan meng-UPDATE record
lama (jika ada) sedangkan jika belum ada maka proses INSERT akan terjadi seperti
biasa

terima kasih sebelumnya

#22025 From: "Subekti Pranoto" <sub3xt1@...>
Date: Thu Nov 26, 2009 12:46 am
Subject: Re: Ga bisa connect lagi !!!
sub3xt1@...
Send Email Send Email
 
coba cek service listener sudah jalan apa belum?
C:\> lsnrctl status

coba ping nama komputer
C:\> ping nama_komputermu

munculnya IP (192.168.x.y) atau 127.0.0.1 ?
jika 127.0.0.1 yg muncul, edit file "C:\WINDOWS\system32\drivers\etc\hosts"
dan pastikan entri ini ada di sana.
127.0.0.1        localhost.localdomain
192.168.1.1    nama_komputermu

nama identifier di tnsnames.ora apa?
coba cek dulu dengan tnsping
C:\> tnsping nama_identifier

saya yakin masalahnya ada di service listener yg blm jalan.

   ----- Original Message -----
   From: Mx7
   To: indo-oracle@yahoogroups.com
   Sent: Wednesday, November 25, 2009 8:31 AM
   Subject: [indo-oracle] Ga bisa connect lagi !!!



   Met kenal semuanya ...
   saia baru banget belajar ORACLE & yang pasti ada masalah tentang Oracle ...
masalahnya gini :
   Hari pertama ... saia dah berhasil install .. trus berhasil juga connect pake
cara :

   sqlpuls / nolog
   SQL> connect mizzu/mizzu as sysdba

   dan langsung connect ...
   buat table awal juga berhasil...

   Hari kedua & seterusnya ... tiba2 ga bisa connect, dah coba semua service di
Oracle di aktifkan (service.msc), listener juga dah jalan, tapi tetep ga bisa
connect ...

   berikut hasil yang di cmd :

   C:\Documents and Settings\Owner>sqlplus /nolog
   SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 25 08:24:56 2009
   Copyright (c) 1982, 2007, Oracle. All rights reserved.

   SQL> connect mizzu/mizzu as sysdba
   ERROR:
   ORA-12560: TNS:protocol adapter error

   Tolong ... saia harus gimana lagi biar bisa connect ....
   mohon bimbingannya ....
   thx ..

   [Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

#22024 From: Iwe <iwe2106@...>
Date: Wed Nov 25, 2009 4:07 pm
Subject: Re: Re: compress table / tablespace
iwe2106
Offline Offline
Send Email Send Email
 
Just for sharing untuk Oracle DB <11gR2. Saya pernah kena bug. Hit error ORA-600
[6780] Ketika menggunakan compress tablespace ALL OPERATIONS (DML).

Solved di 11gR2. Kalau yang punya akses metalink, see Bug 6709070 (bagus nih
angkanya buat no HP hehehe).

salam DBA,
Iwe

--- On Wed, 11/25/09, yulius_wibowo <yulius_wibowo@...> wrote:

From: yulius_wibowo <yulius_wibowo@...>
Subject: [indo-oracle] Re: compress table / tablespace
To: indo-oracle@yahoogroups.com
Date: Wednesday, November 25, 2009, 1:25 PM

Penggunaan option COMPRESS di level table atau tablespace sbb:
1. Utk 9iR2 & 10g:
- data hanya akan dikompres ketika data dimasukkan ke dalam table menggunakan :
- direct path insert (INSERT INTO SELECT ) dengan hint APPEND
- direct path load (menggunakan SQL*Loader)
- CTAS (CREATE TABLE ... COMPRESS AS SELECT)

Note: compression rate-nya akan lebih bagus kalau menggunakan ORDER BY CLAUSE.

2. 11g:
- bisa spt 9iR2 atau 10g
- juga bisa utk ALL OPERATIONS (DML:: INSERT biasa & UPDATE)

cmiiw,
bw


--- In indo-oracle@yahoogroups.com, "a j" <antdrie_j@...> wrote:
>
> wah, saya menggunakan versi 10.2.0.4.
> kalau syntax "alter tablespace <nama_tablespace> default compress" ini buat
apa yah ?
> katanya compress ini bisa me reduce space yg ada
>
> trims
>
> --- In indo-oracle@yahoogroups.com, "Faiz" <faiz.jahja@> wrote:
> >
> > Kalau tidak salah option ini ada di Oracle 11g.
> >
> > Untuk compress table dan column adanya di Oracle 10gR2 Exadata.
> >
> > .
> > -----Original Message-----
> > From: "a j" <antdrie_j@>
> > Date: Wed, 25 Nov 2009 03:45:21
> > To: <indo-oracle@yahoogroups.com>
> > Subject: [indo-oracle] compress table / tablespace
> >
> > ada yg sudah pernah melakukan compress table/tablespace ?
> > untuk syntax nya bagai mana yah ?
> > apa untung dan ruginya compress table/tablespace ini.
> >
> > trims
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>




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

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: indo-oracle-unsubscribe@yahoogroups.com
Website: http://indooracle.wordpress.com
http://www.facebook.com/group.php?gid=51973053515
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.comYahoo! Groups Links








[Non-text portions of this message have been removed]

#22023 From: "yanaora" <yanaora@...>
Date: Wed Nov 25, 2009 2:07 pm
Subject: Bls: Re: Tanya OCA Certification Requirement
yanaora
Offline Offline
Send Email Send Email
 
@all

Thanks berat atas info n sharingnya
Kebetulan Aku tinggal di bandung n ada juga tempat test yang deket rumah

#22022 From: Mx7 <iqbal_gamers@...>
Date: Wed Nov 25, 2009 1:31 am
Subject: Ga bisa connect lagi !!!
iqbal_gamers
Offline Offline
Send Email Send Email
 
Met kenal semuanya ...
saia baru banget belajar ORACLE & yang pasti ada masalah tentang Oracle ...
masalahnya gini :
Hari pertama ... saia dah berhasil install .. trus berhasil juga connect pake
cara :

sqlpuls / nolog
SQL> connect mizzu/mizzu as sysdba

dan langsung connect ...
buat table awal juga berhasil...

Hari kedua & seterusnya  ... tiba2 ga bisa connect, dah coba semua service di
Oracle di aktifkan (service.msc), listener juga dah jalan, tapi tetep ga bisa
connect ...

berikut hasil yang di cmd :

C:\Documents and Settings\Owner>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 25 08:24:56 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> connect mizzu/mizzu as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

Tolong ... saia harus gimana lagi biar bisa connect ....
mohon bimbingannya ....
thx ..




[Non-text portions of this message have been removed]

#22021 From: "bendot" <tooharz@...>
Date: Wed Nov 25, 2009 4:16 am
Subject: implementasi deduktive database
tooharz
Offline Offline
Send Email Send Email
 
buat senior-senior database neh,,,
mohon pencerahannya ya....

ada yang pernah riset tentang deductive database ngga???

saya masih belum ada gambaran,,script yang bakalan diimplementasikan di DBMS tu
seperti apa ya??? seperti script querynya gitu....

ada yang bisa memberikan contoh atau referensi ????

terima kasih atas tanggapannya...

#22020 From: Adi Supriyanto <adidoyz@...>
Date: Wed Nov 25, 2009 9:14 am
Subject: Bls: membutuhkan aplikasi Rumah sakit, travel , E learning, Lab bahasa, ERP, hotel ,
adidoyz
Offline Offline
Send Email Send Email
 
salah satu dari software yg di butuhkan bisa tidak pak ?

thx



       Yahoo! Mail Kini Lebih Cepat dan Lebih Bersih. Rasakan bedanya sekarang!
http://id.mail.yahoo.com

[Non-text portions of this message have been removed]

#22019 From: Adiws2006 Wijaya Sutanto <adiws2006@...>
Date: Tue Nov 24, 2009 3:36 pm
Subject: Re: Tanya SQL untuk menampilkan data yang unique (saja)
adiws2006
Offline Offline
Send Email Send Email
 
Select Unique Loc||Item||Qty From Nama_table
Maka Yang Muncul Adalah

1       A01    4
1       B01    8
2       A01    2
3       C01    3

Oke Semoga Bisa membantu..


  Regards
Adi Wijaya Sutanto

PT PERKASA PILAR UTAMA




________________________________
From: Jack Mania <j4ckm4n@...>
To: indo-oracle@yahoogroups.com
Sent: Fri, November 20, 2009 10:13:12 AM
Subject: [indo-oracle] Tanya SQL untuk menampilkan data yang unique (saja)


Dear Rekan Indo Oracle yang saya hormati,

Mohon sharingnya ya, mungkin ada yang punya pengalaman/bisa bantu.
Saya punya data seperti berikut :
Loc   Item   Qty
1       A01    2
1       A01    2
1       B01    4
1       B01    4
2       A01    2
2       A01    2
3       C01    3

Pertanyaan saya bagaimana SQL-nya jika saya ingin menampilkan data spt berikut :
Loc   Item   Qty
1       A01    4
1       B01    8

Untuk yang di Loc 2 dan 3 tidak dimunculkan karena dia
tidak uniq (hanya berisi 1 part dalam  loc)

Terima kasih sebelumnya atas bantuannya.

Salam,
Andika

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

#22018 From: "imam_biz" <imam_biz@...>
Date: Wed Nov 25, 2009 8:19 am
Subject: membutuhkan aplikasi Rumah sakit, travel , E learning, Lab bahasa, ERP, hotel ,
imam_biz
Offline Offline
Send Email Send Email
 
Kami sedang membutuhkan beberapa aplikasi untuk client kami. Adapun spesifikasi
sbb :

1. Aplikasi Rumah sakit
2. Aplikasi Travel Agent
3. Aplikasi Hotel
4. Aplikasi ERP
5. Aplikasi Untuk Lab Bahasa Inggris
6. Aplikasi untul E learning.
7. Aplikasi Human Resource

Seluruh aplikasi diatas di utamakan yang jalan under web
Aplikasi sudah siap pakai dan stabil , bukan yang baru di develop.
Sudah mempunyai client yang memakai
Dapat di terapkan dengan konsep bisnis model ASP ( application service provider
).
Mempunyai Customer support yang jelas.

Jika rekan-rekan mempunyai aplikasi atau informasi silahkan memberikan proposal
Fitur aplikasi dan penawaran harga ke email imam.syaiful@...

kami akan mengundang untuk demo di tempat kami dijakarta jika aplikasi yang di
tawarkan sesuai dengan permintaan customer.



Terima kasih atas bantuanya .
salam
Imam Syaiful

#22017 From: stanleycia <stanleycia@...>
Date: Wed Nov 25, 2009 6:39 am
Subject: Re: Re: compress table / tablespace
stanley_cia
Online Now Online Now
Send Email Send Email
 
Yang menarik di 11g, compression juga dipakai di redo log transport sehingga
bisa menghemat b/w dan memperkecil lag dari primary ke standby.

2009/11/25 yulius_wibowo <yulius_wibowo@...>

>
>
> Penggunaan option COMPRESS di level table atau tablespace sbb:
> 1. Utk 9iR2 & 10g:
> - data hanya akan dikompres ketika data dimasukkan ke dalam table
> menggunakan :
> - direct path insert (INSERT INTO SELECT ) dengan hint APPEND
> - direct path load (menggunakan SQL*Loader)
> - CTAS (CREATE TABLE ... COMPRESS AS SELECT)
>
> Note: compression rate-nya akan lebih bagus kalau menggunakan ORDER BY
> CLAUSE.
>
> 2. 11g:
> - bisa spt 9iR2 atau 10g
> - juga bisa utk ALL OPERATIONS (DML:: INSERT biasa & UPDATE)
>
> cmiiw,
> bw
>
>
> --- In indo-oracle@yahoogroups.com <indo-oracle%40yahoogroups.com>, "a j"
> <antdrie_j@...> wrote:
> >
> > wah, saya menggunakan versi 10.2.0.4.
> > kalau syntax "alter tablespace <nama_tablespace> default compress" ini
> buat apa yah ?
> > katanya compress ini bisa me reduce space yg ada
> >
> > trims
> >
> > --- In indo-oracle@yahoogroups.com <indo-oracle%40yahoogroups.com>,
> "Faiz" <faiz.jahja@> wrote:
> > >
> > > Kalau tidak salah option ini ada di Oracle 11g.
> > >
> > > Untuk compress table dan column adanya di Oracle 10gR2 Exadata.
> > >
> > > .
> > > -----Original Message-----
> > > From: "a j" <antdrie_j@>
> > > Date: Wed, 25 Nov 2009 03:45:21
> > > To: <indo-oracle@yahoogroups.com <indo-oracle%40yahoogroups.com>>
> > > Subject: [indo-oracle] compress table / tablespace
> > >
> > > ada yg sudah pernah melakukan compress table/tablespace ?
> > > untuk syntax nya bagai mana yah ?
> > > apa untung dan ruginya compress table/tablespace ini.
> > >
> > > trims
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>


[Non-text portions of this message have been removed]

#22016 From: "yulius_wibowo" <yulius_wibowo@...>
Date: Wed Nov 25, 2009 6:25 am
Subject: Re: compress table / tablespace
yulius_wibowo
Offline Offline
Send Email Send Email
 
Penggunaan option COMPRESS di level table atau tablespace sbb:
1. Utk 9iR2 & 10g:
- data hanya akan dikompres ketika data dimasukkan ke dalam table menggunakan :
- direct path insert (INSERT INTO SELECT ) dengan hint APPEND
- direct path load (menggunakan SQL*Loader)
- CTAS (CREATE TABLE ... COMPRESS AS SELECT)

Note: compression rate-nya akan lebih bagus kalau menggunakan ORDER BY CLAUSE.

2. 11g:
- bisa spt 9iR2 atau 10g
- juga bisa utk ALL OPERATIONS (DML:: INSERT biasa & UPDATE)

cmiiw,
bw


--- In indo-oracle@yahoogroups.com, "a j" <antdrie_j@...> wrote:
>
> wah, saya menggunakan versi 10.2.0.4.
> kalau syntax "alter tablespace <nama_tablespace> default compress" ini buat
apa yah ?
> katanya compress ini bisa me reduce space yg ada
>
> trims
>
> --- In indo-oracle@yahoogroups.com, "Faiz" <faiz.jahja@> wrote:
> >
> > Kalau tidak salah option ini ada di Oracle 11g.
> >
> > Untuk compress table dan column adanya di Oracle 10gR2 Exadata.
> >
> > .
> > -----Original Message-----
> > From: "a j" <antdrie_j@>
> > Date: Wed, 25 Nov 2009 03:45:21
> > To: <indo-oracle@yahoogroups.com>
> > Subject: [indo-oracle] compress table / tablespace
> >
> > ada yg sudah pernah melakukan compress table/tablespace ?
> > untuk syntax nya bagai mana yah ?
> > apa untung dan ruginya compress table/tablespace ini.
> >
> > trims
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

#22015 From: "a j" <antdrie_j@...>
Date: Wed Nov 25, 2009 4:10 am
Subject: Re: compress table / tablespace
antdrie_j
Offline Offline
Send Email Send Email
 
wah, saya menggunakan versi 10.2.0.4.
kalau syntax "alter tablespace <nama_tablespace> default compress" ini buat apa
yah ?
katanya compress ini bisa me reduce space yg ada

trims

--- In indo-oracle@yahoogroups.com, "Faiz" <faiz.jahja@...> wrote:
>
> Kalau tidak salah option ini ada di Oracle 11g.
>
> Untuk compress table dan column adanya di Oracle 10gR2 Exadata.
>
> .
> -----Original Message-----
> From: "a j" <antdrie_j@...>
> Date: Wed, 25 Nov 2009 03:45:21
> To: <indo-oracle@yahoogroups.com>
> Subject: [indo-oracle] compress table / tablespace
>
> ada yg sudah pernah melakukan compress table/tablespace ?
> untuk syntax nya bagai mana yah ?
> apa untung dan ruginya compress table/tablespace ini.
>
> trims
>
>
>
>
> [Non-text portions of this message have been removed]
>

#22014 From: "Faiz" <faiz.jahja@...>
Date: Wed Nov 25, 2009 4:02 am
Subject: Re: compress table / tablespace
faiz.yahya...
Offline Offline
Send Email Send Email
 
Kalau tidak salah option ini ada di Oracle 11g.

Untuk compress table dan column adanya di Oracle 10gR2 Exadata.

.
-----Original Message-----
From: "a j" <antdrie_j@...>
Date: Wed, 25 Nov 2009 03:45:21
To: <indo-oracle@yahoogroups.com>
Subject: [indo-oracle] compress table / tablespace

ada yg sudah pernah melakukan compress table/tablespace ?
untuk syntax nya bagai mana yah ?
apa untung dan ruginya compress table/tablespace ini.

trims




[Non-text portions of this message have been removed]

Messages 22014 - 22043 of 22043   Newest  |  < Newer  |  Older >  |  Oldest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help