SQL> connect sys/ as sysdba Connected. SQL> create user dbufr identified by dbufr 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users 5 quota 0k on system 0k on sysaux; quota 0k on system 0k on sysaux * ERROR at line 5: ORA-00922: missing or invalid option SQL> create user dbufr identified by dbufr 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users 5 quota 0k on system 0k on sysaux; quota 0k on system 0k on sysaux * ERROR at line 5: ORA-00922: missing or invalid option SQL> create user dbufr identified by dbufr 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users 5 quota 0k on system 6 quota 0k on sysaux; create user dbufr identified by dbufr * ERROR at line 1: ORA-01920: user name 'DBUFR' conflicts with another user or role name SQL> create user dbufr2 identified by dbufr2 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users 5 quota 0k on system 6 quota 0k on sysaux; User created. SQL> connect dbufr2; ERROR: ORA-01045: user DBUFR2 lacks CREATE SESSION privilege; logon denied Warning: You are no longer connected to ORACLE. SQL> on ne peut pas se loger SP2-0734: unknown command beginning "on ne peut..." - rest of line ignored. SQL> spol off SP2-0042: unknown command "spol off" - rest of line ignored. SQL> spool off SQL> create role master2; SP2-0640: Not connected SQL> connect sys/ as sysdba Connected. SQL> create role master2; Role created. SQL> grant create session,create table, create view, create type, create procedure, create synonym, create sequence, execute any procedure to master2; Grant succeeded. SQL> grant master2 to dbufr; Grant succeeded. SQL> grant master2 to dbufr2; Grant succeeded. SQL> connect dbufr2; Connected. SQL> create user dbufr3 identified by dbufr3 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users 5 quota 0k on system 6 quota 0k on sysau; create user dbufr3 identified by dbufr3 * ERROR at line 1: ORA-01031: insufficient privileges SQL> connect sys/ as sysdba Connected. SQL> create user 2 as; as * ERROR at line 2: ORA-01935: missing user or role name SQL> l2 2* as SQL> l2 c:a:l: SP2-0225: invalid ending line number SQL> c:a:l: 2* ls SQL> create user aaa identified as aaa; create user aaa identified as aaa * ERROR at line 1: ORA-00924: missing BY keyword SQL> create user aaa identified by aaa; User created. SQL> l1 1* create user aaa identified by aaa SQL> c:a:b: 1* crebte user aaa identified by aaa SQL> l 1* crebte user aaa identified by aaa SQL> / crebte user aaa identified by aaa * ERROR at line 1: ORA-00900: invalid SQL statement SQL> c:b:a; 1* create user aaa identified by aaa SQL> / create user aaa identified by aaa * ERROR at line 1: ORA-01920: user name 'AAA' conflicts with another user or role name SQL> connect dbufr2; Connected. SQL> create type adresse_type 2 as object 3 ( numero NUMBER, 4 rue varchar2(30), 5 ville carchar2(30), 6 codepostal varchar2(30)); 7 / Warning: Type created with compilation errors. SQL> show error Errors for TYPE ADRESSE_TYPE: LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 PL/SQL: Compilation unit analysis terminated 5/7 PLS-00201: identifier 'CARCHAR2' must be declared SQL> l5 5* ville carchar2(30), SQL> c:carchar:varchar: 5* ville varchar2(30), SQL> / Type created. SQL> create type pays_type 2 as object 3 ( 4 codepays varchar2(3), 5 nompays varchar2(30));/ 6 / Warning: Type created with compilation errors. SQL> show error Errors for TYPE PAYS_TYPE: LINE/COL ERROR -------- ----------------------------------------------------------------- 5/23 PLS-00103: Encountered the symbol "/" The symbol "/" was ignored. SQL> l5 5* nompays varchar2(30));/ SQL> c:;/:;: 5* nompays varchar2(30)); SQL> / Type created. SQL> create type telephone_elt_vry_type 2 as object 3 (numtel varchar2(20)); 4 / Type created. SQL> create type telephone_vry_type as 2 varray53) of telephone_elt_vry_type; 3 / Warning: Type created with compilation errors. SQL> show error Errors for TYPE TELEPHONE_VRY_TYPE: LINE/COL ERROR -------- ----------------------------------------------------------------- 2/1 PLS-00103: Encountered the symbol "VARRAY53" when expecting one of the following: array VARRAY_ table object fixed varying opaque sparse SQL> c:varray5:varray( 2* varray(3) of telephone_elt_vry_type; SQL> / Type created. SQL> show user USER is "DBUFR2" SQL> create type enfant_elt_nt_type as object 2 (prenomenf varchar2(25), 3 ageenf number, 4 etude varchar(30) 5 ); 6 / Type created. SQL> create type enfant_nt_type as table of enfant_elt_nt_type; 2 / Type created. SQL> Il y a 2 tad : monovalu‚ et multimvalu‚ SP2-0734: unknown command beginning "Il y a 2 t..." - rest of line ignored. SQL> create type personne_type 2 as object 3 ( 4 codePErs number, 5 nompers varchar2530), 6 prenompers varchar2(25), 7 sexepers varchar2(1), 8 datenaissance date, 9 adresse adresse_type, 10 telephone_vry telephone_vry_type, 11 enfant_nt enfant_nt_type, 12 ststic procedure insererpersonne 13 (nompressonne in varchar2, 14 prenompersonne in varchar2, 15 adressepersonne in adresse_type), 16 static procedure insererpersonne 17 (nompersonne in varchar2, 18 prenompersonne in varchar2), 19 static procedure ajouterpersonne 20 (nompersonne in varchar2, 21 prenompersonne in varchar2, 22 datenaissancepersonne in date), 23 member procedure majdatenaissance 24 (nouvelledatenaissance in date), 25 member function fetage return number, 26 member procedure setnouvelleadresse 27 (nouvelleadresse in adresse_type)); 28 / Warning: Type created with compilation errors. SQL> show error Errors for TYPE PERSONNE_TYPE: LINE/COL ERROR -------- ----------------------------------------------------------------- 5/21 PLS-00103: Encountered the symbol "," when expecting one of the following: ; not alter final instantiable 12/8 PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following: LONG_ double ref char time timestamp interval date binary national character nchar 15/33 PLS-00103: Encountered the symbol "," when expecting one of the LINE/COL ERROR -------- ----------------------------------------------------------------- following: ; is with authid as cluster order using external deterministic parallel_enable pipelined 27/35 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin function package pragma procedure subtype type use form current cursor SQL> l5 5* nompers varchar2530), SQL> c:2530:2(30: 5* nompers varchar2(30), SQL> l12 12* ststic procedure insererpersonne SQL> c:sts:sta: 12* static procedure insererpersonne SQL> / Type created. SQL> spool off SQL> create type visa_type as object 2 ( codevisa number, 3 datedemande date, 4 dateentree date, 5 datesortie date, 6 numeropasseport varchar2(15), 7 motifsejour varchar2(80), 8 ref_personne ref personne_type, 9 ref_pays ref pays_type); 10 / Type created. SQL> spool off