Pozdrav!
Sa Oracle-om nemam nikakva iskustva, a potrebno mi je za potrebe instalacije nekog softvera da prvo manuelno pripremim Oracle bazu, a install procedura kasnije kreira tabele i šta već treba...
Install Guide kaže sledeće:
1. Create an Oracle instance.
The initial recommended Oracle tablespace sizes are:
User table space approximately 500 MB
System table space approximately 700 MB
Undo table space to 1 GB
Temp table space to 1 GB
Index table space to 500 MB
2. Initialize schema parameters using the Oracle Settings table found at the end of this section.
3. Create an Oracle user and password pair.
4. Grant the following access to the new user:
For Oracle 10g databases:
Grant CONNECT
Grant RESOURCE
Grant CREATE VIEW
Grant CREATE SEQUENCE
Oracle Parameters
Parameter Name Value Comment
DB_BLOCK_SIZE 8,192 Must be set during schema creation
DB_CACHE_SIZE 100,000,000
Parameter Name Value Comment
OPTIMIZER_MODE CHOOSE Note: This setting is crucial.
SHARED_POOL_SIZE 50,000,000
LOG_CHECKPOINT_INTERVAL 0
DML_LOCKS 1,000
PROCESSES 500
LOG_BUFFER 655,360
OPEN_CURSORS 2,000
SORT_AREA_SIZE 5,000,000
MAX_DUMP_FILE_SIZE 10,240
DB_FILES 121 Operating system dependent
TIMED_STATISTICS TRUE
Oracle baza je 10g, na Windows 2008 x64 Serveru, ako je bitno.
Dakle, mene zanima, ako neko ima živaca da me ukratko uputi, šta mi je potrebno od alata i admin prava da bih mogao da sa što manje muke kreiram bazu i ispoštujem gore navedeno, po mogućstvu nekim vizuelnim utilitijem koji radi na Windowsu. Sa SQL Server Management Studio-om i MS SQL serverom se inače snalazim.
Hvala!