1. ato klo mo liat table punya user tertentu, connect
aja ke user itu, trus commandnya, 'select * from tab;'
co:
SQL> conn scott/tiger;
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
CUSTOMER TABLE
PRICE TABLE
DEPT TABLE
EMP TABLE
BONUS TABLE
2. iya, create database itu optional koq, kita bisa
lgs minta di creatin, bisa juga create manual..
klo mo gampang create database, pastiin klo database
kita omf. di initora nya, isi parameter:
-db_create_file_dest (dest. utk datafile kita)
-db_create_online_log_dest (dest. utk ctlfile&logfile)
co:
db_create_file_dest=/u01/test/datafile
db_create_online_log_dest_1=/u01/test/logfile
klo udh, command create databasenya:
create database test
default temporary tablespace temp01 -> utk temp
undo management undotbs01 -> utk undo
emm, utk create db, os usernya mesti pake user yg
dipake utk install software oracle. di oraclenya hrs
connect sbg user yg punya privilage sysdba.
utk gui nya mungkin bisa coba '.oemapp console' lwt
cli.
regards,
[L]
--- "betabetha ." <[EMAIL PROTECTED]> wrote:
> 1. untuk melihat table2 yang ada coba dengan
> perintah
> select owner, table_name, tablespace_name from
> dba_tables;
>
> 2. pada waktu install oracle ada pilihan database
> mau diinstall atau
> tidak gitu.
> kalo pingin create database manual dari sqlplus
> pastikan dahulu apakah
> init.ora ada dan setelah itu startupnya harus berada
> dalam keadaan
> nomount. dan gunakan user sys
> ini ada contoh create database perintahnya:
> SQL> STARTUP NOMOUNT;
>
> SQL> CREATE DATABASE DMASTER
> USER SYS IDENTIFIED BY CSA
> USER SYSTEM IDENTIFIED BY CSA
> LOGFILE GROUP 1
>
('C:\ORADATA\DATA\DMASTER\LOG1A','C:\ORADATA\DATA\DMASTER\LOG1B')
> SIZE
> 20M,
> GROUP 2
>
('C:\ORADATA\DATA\DMASTER\LOG2A','C:\ORADATA\DATA\DMASTER\LOG2B')
> SIZE
> 20M,
> GROUP 3
>
('C:\ORADATA\DATA\DMASTER\LOG3A','C:\ORADATA\DATA\DMASTER\LOG3B')
> SIZE
> 20M
> DATAFILE 'C:\ORADATA\DATA\DMASTER\SYS01.ORA' SIZE
> 512M
> SYSAUX DATAFILE
> 'C:\ORADATA\DATA\DMASTER\SYS01AUX.ORA' SIZE 128M
> DEFAULT TABLESPACE USERS DATAFILE
> 'C:\ORADATA\DATA\DMASTER\USER01.ORA' SIZE 512M
> DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
> 'C:\ORADATA\DATA\DMASTER\TEMP01.ORA' SIZE 128M
> UNDO TABLESPACE UNDOTBS1 DATAFILE
> 'C:\ORADATA\DATA\DMASTER\UNDO01.ORA'
> SIZE 128M ;
>
>
> On 3/16/06, Ryant Febrian <[EMAIL PROTECTED]>
> wrote:
> > iya benar, databasenya belum distartup. terima
> kasih :))
> >
> > selain itu saya ingin bertanya,
> > perintah apa bila mau melihat table - table di
> database oracle? saya pake perintah "show tables" ga
> mau.
> > lalu klo di oracle bukannya kita tidak perlu
> membuat database lagi? dan klo mau membuat database
> dari sqlplus gimana caranya? langsung ketik create
> database <nama_database> ? apakah user yang saya
> pakai harus root?? saya menggunakan linux dan saya
> menggunakan sqlplus pada command line.
> > kemudian di taskbar pada linux saya, tidak muncul
> shortcut yang biasanya ada di windos start menu.
> untuk memunculkannya gimana?
> >
> > Terima kasih sebelumnya,
> > Andes
> >
> > Leonard Sukendro <[EMAIL PROTECTED]> wrote:
> > klo boleh tau, abis install oracle, udah create
> > database nya bln ya, pak? ato database nya bln di
> > startup?
> > pas connect ke sys, ada pesan connected to idle
> > instance gk?
> >
> > regards,
> > [L]
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Mail
> > Use Photomail to share photos without annoying
> attachments.
> >
> > [Non-text portions of this message have been
> removed]
> >
> >
> >
> > --
> > -----------I.N.D.O - O.R.A.C.L.E---------------
> > Keluar: [EMAIL PROTECTED]
> > Website: http://indo-oracle.lizt.org (NEW)
> > -----------------------------------------------
> >
> > Bergabung dengan Indonesia Thin Client User
> Groups,
> > Terminal Server, Citrix, New Moon Caneveral, di:
> > http://indo-thin.vze.com
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
