Criação de BD

[VINICIUS RAMOS 0]

Falaí galera,Alguém sabe a sintaxe completa para a criação de um banco em ORACLE?

[alphamek 2]

Olá,

 

Para criar um banco de dados basta seguir as instruções SQL abaixo:

 

CREATE DATABASECreate a database.Syntax:   CREATE DATABASE database_name optionsOptions:   DATAFILE filespec AUTOEXTEND OFF   DATAFILE filespec AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]   MAXDATAFILES int   EXTENT MANAGEMENT LOCAL   DEFAULT TEMPORARY TABLESPACE tablespace [TEMPFILE filespec] [EXTENT MANAGEMENT LOCAL] [UNIFORM [SIZE int K | M]]   UNDO TABLESPACE tablespace [DATAFILE filespec]   LOGFILE [GROUP int] filespec   MAXLOGFILES int   MAXLOGMEMBERS int   MAXLOGHISTORY int   MAXINSTANCES int   ARCHIVELOG | NOARCHIVELOG   CONTROLFILE REUSE   CHARACTER SET charset   NATIONAL CHARACTER SET charset   SET TIMEZONE = 'time_zone_region'   SET TIMEZONE = '{+|-} hh:mm'   FORCE LOGGING   USER SYS IDENTIFIED BY password   USER SYSTEM IDENTIFIED BY passwordIf more than one DATAFILE or LOGFILE is to be specified - several 'filespecs' can be included in one clause separated with commas e.g. DATAFILE filespec1, filespec2, filespec3If you do not specify both system passwords, Oracle will create the default passwords "change_on_ install" for SYS and "manager" for SYSTEM.After creating the database, you can change between ARCHIVELOG mode and NOARCHIVELOG mode with the ALTER DATABASE statement.Example-- Create a database with the SID of TEST and char set WE8ISO8859P1CREATE DATABASE TESTLOGFILE 'E:\OraData\TEST\LOG1TEST.ORA' SIZE 2M,'E:\OraData\TEST\LOG2TEST.ORA' SIZE 2M,'E:\OraData\TEST\LOG3TEST.ORA' SIZE 2M,'E:\OraData\TEST\LOG4TEST.ORA' SIZE 2M,'E:\OraData\TEST\LOG5TEST.ORA' SIZE 2MEXTENT MANAGEMENT LOCALMAXDATAFILES 100DATAFILE 'E:\OraData\TEST\SYS1TEST.ORA' SIZE 50 MDEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'E:\OraData\TEST\TEMP.ORA' SIZE 50 MUNDO TABLESPACE undo DATAFILE 'E:\OraData\TEST\UNDO.ORA' SIZE 50 MNOARCHIVELOGCHARACTER SET WE8ISO8859P1;

Mas, lembre-se, criar um script de DATABASE não criará um instância e serviços Oracle. Existe todo um procedimento para criação dos serviços, instância e banco de dados Oracle.

 

Abraços, B)

[VINICIUS RAMOS 0]

vlw

[alphamek 2]

http://forum.imasters.com.br/public/style_emoticons/default/thumbsup.gif