Hola

SQL*Plus: Release 10.2.0.1.0 - Production on Mar Feb 21 16:53:50 2012

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

SQL> CONNECT
Introduzca el nombre de usuario: SYSTEM
Introduzca la contrase±a:
Conectado.
SQL> SPOOL C:\LAB31\Lab31.txt
SQL> SET TIME ON
16:54:32 SQL> SET EDITF C:\LAB31\edicion.txt
16:55:03 SQL> CREATE TABLESPACE ts_lab1
16:55:51 2 DATAFILE'C:\LAB31\CinLab1.dbf' SIZE 5M
16:56:31 3 AUTOEXTEND ON MAXSIZE 6M,
16:56:46 4 'C:\LAB31\CinLab2.dbf' SIZE 5M
16:57:12 5 AUTOEXTEND ON MAXSIZE 6M;

Tablespace creado.

16:57:30 SQL> CREATE TEMPORARY TABLESPACE lab1_temp
16:58:02 2 TEMPFILE 'C:\LAB31\cin_temp.dbf' SIZE 10M;

Tablespace creado.

16:58:47 SQL> CREATE USER user_lab1
17:04:05 2 IDENTIFIED BY ulab1
17:04:17 3 DEFAULTTABLESPACE ts_lab1
17:04:30 4 TEMPORARY TABLESPACE lab1_temp
17:04:47 5 QUOTA 3M ON ts_lab1;

Usuario creado.

17:05:10 SQL> GRANT CONNECT TO user_lab1;

Concesi¾n terminada correctamente.

17:05:35 SQL> GRANT RESOURCE TO user_lab1;

Concesi¾n terminada correctamente.

17:05:53 SQL> SELECT tablespace_name
17:06:15 2 FROM dba_tablespaces;

TABLESPACE_NAME------------------------------
SYSTEM
UNDO
SYSAUX
TEMP
USERS
TS_LAB1
LAB1_TEMP

7 filas seleccionadas.

17:06:25 SQL> SELECT file_name, BYTES/1024
17:07:29 2 FROM dba_data_files
17:07:38 3 WHERE tablespace_name = 'USERS';

FILE_NAME
--------------------------------------------------------------------------------

BYTES/1024
----------
C:\ORACLEXE\ORADATA\XE\USERS.DBF
102400

17:07:57 SQL> CREATE TABLE Alumnos17:08:58 2 (Matricula VARCHAR2(10) PRIMARY KEY,
17:09:23 3 Nombre VARCHAR2(40) DEFAULT 'No Capturado',
17:09:49 4 Direccion VARCHAR2(30),
17:10:11 5 Edad NUMBER,
17:10:24 6 CONSTRAINT ch_ED CHECK (Edad > 1));

Tabla creada.

17:10:49 SQL> CREATE TABLE Cursos
17:11:15 2 (idCurso NUMBER(8) PRIMARY KEY,)
17:11:37 3 (idCurso NUMBER(8) PRIMARY KEY,
17:11:42 4
17:11:43SQL> CREATE TABLE Cursos
17:11:48 2 (idCurso NUMBER(8) PRIMARY KEY,
17:11:54 3 Descripcion VARCHAR2(20),
17:12:22 4 Costo NUMBER(7,2),
17:12:42 5 CONSTRAINT ch_cos CHECK (Costo > 0));

Tabla creada.

17:13:05 SQL> CREATE TABLE Alumnos_Cursos
17:13:53 2 (Matricula VARCHAR(10),
17:14:22 3 idCurso NUMBER(8),
17:14:42 4 CONSTRAINT pk_ac PRIMARY KEY (Matricula, idCurso)
17:15:495 CONSTRAINT fk_al FOREING KEY (Matricula) REFERENCES Alumnos(Matric
ula),
17:16:44 6 CONSTRAINT fk_cu FOREING KEY (idCurso) REFERENCES Cursos(idCurso))
;
CONSTRAINT fk_al FOREING KEY (Matricula) REFERENCES Alumnos(Matricula),
*
ERROR en lÝnea 5:
ORA-00907: falta el parÚntesis derecho

17:17:22 SQL> edit
Escrito file C:\LAB31\edicion.txt

1 CREATE TABLE Alumnos_Cursos
2 (MatriculaVARCHAR(10),
3 idCurso NUMBER(8),
4 CONSTRAINT pk_ac PRIMARY KEY (Matricula, idCurso),
5 CONSTRAINT fk_al FOREING KEY (Matricula) REFERENCES Alumnos(Matricula),
6* CONSTRAINT fk_cu FOREING KEY (idCurso) REFERENCES Cursos(idCurso))
17:17:38 SQL> /
CONSTRAINT fk_al FOREING KEY (Matricula) REFERENCES Alumnos(Matricula),
*
ERROR en lÝnea 5:
ORA-00907: faltael parÚntesis derecho

17:17:41 SQL> edit
Escrito file C:\LAB31\edicion.txt

1 CREATE TABLE Alumnos_Cursos
2 (Matricula VARCHAR2(10),
3 idCurso NUMBER(8),
4 CONSTRAINT PK_ac PRIMARY KEY (Matricula, idCurso),
5 CONSTRAINT FK_al FOREIGN KEY (Matricula) REFERENCES Alumnos(Matricula),
6* CONSTRAINT FK_cu FOREIGN KEY (idCurso) REFERENCES Cursos(idCurso))
17:21:58 SQL> /

Tablacreada.

17:22:02 SQL> INSERT INTO Alumnos VALUES(1465123, 'Cintia Sanchez Palomares', 'S
exta #826', 19);

1 fila creada.

17:23:17 SQL> INSERT INTO Alumnos VALUES(1392389, 'Frank Junior S. ', 'Quinta Av
enida #8943', 24);

1 fila creada.

17:25:32 SQL> SELECT * FROM Alumnos;

MATRICULA NOMBRE
---------- ----------------------------------------
DIRECCION EDAD...