Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10gR2 for solaris (64bit), AIX and HP released

Re: 10gR2 for solaris (64bit), AIX and HP released

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 31 Aug 2005 16:06:15 +0100
Message-ID: <7765c89705083108064abde8e0@mail.gmail.com>


SQL> CONN /@ORCL AS SYSDBA
Connected.
SQL> SELECT COMP_NAME,VERSION,STATUS
2 FROM DBA_REGISTRY;
Oracle9i Catalog Views
9.2.0.6.0 VALID Oracle9i Packages and Types
9.2.0.6.0 VALID Oracle Workspace Manager
9.2.0.1.0 VALID JServer JAVA Virtual Machine
9.2.0.6.0 VALID Oracle XDK for Java
9.2.0.8.0 VALID Oracle9i Java Packages
9.2.0.6.0 VALID Oracle interMedia
9.2.0.6.0 VALID Spatial
9.2.0.6.0 VALID Oracle Text
9.2.0.6.0 VALID Oracle Ultra Search
9.2.0.6.0 INVALID 10 rows selected.

SQL> @CREATEUSER
Enter User to Create: MLADEN
Enter Password: MLADEN
Enter Default Tablespace: USERS
Enter Temporary Tablespace: TEMP
drop user MLADEN cascade
*
ERROR at line 1:
ORA-01918: user 'MLADEN' does not exist

User created.

Grant succeeded.

SQL> CONN MLADEN/MLADEN_at_ORCL
Connected.
SQL> CREATE TABLE T1(C1 NUMBER,C2 CLOB); Table created.

SQL> ALTER TABLE T1 ADD CONSTRAINT
2 PK_T1 PRIMARY KEY(C1); Table altered.

SQL> CONN /@ORCL AS SYSDBA
Connected.
SQL> @EXTRACT_SCHEMA
Enter password for SYSTEM user: PASSWORD Enter tnsnames entry for database: ORCL
Enter User name to script: MLADEN
Enter Create Script name to generate: CREATE_MLADEN spool c:\scripts\utils\CREATE_MLADEN.sql col ddl_col form a80 word_wrapped
exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,
'STORAGE', FALSE);

exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,
'SQLTERMINATOR', TRUE);

exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,
'TABLESPACE', TRUE);

exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,
'SEGMENT_ATTRIBUTES', FALSE);

exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,
'CONSTRAINTS_AS_ALTER', true );

prompt 'Creating User.... '
select dbms_metadata.get_ddl('USER',u.username) ddl_col FROM DBA_users u where username = 'MLADEN';
/* Grants Come next - expect unhelpful errors */ prompt 'Creating Role Grants.... '
SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','MLADEN') FROM DUAL; prompt 'Creating System Grants.... '
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','MLADEN') FROM DUAL; prompt 'Creating Object Grants.... '
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','MLADEN') FROM DUAL; prompt 'Creating Tables.... '
select dbms_metadata.get_ddl('TABLE',t.table_name,'MLADEN') ddl_col FROM DBA_TABLES t WHERE OWNER = 'MLADEN';
prompt 'Creating Indexes.... '
select dbms_metadata.get_ddl('INDEX',i.index_name,'MLADEN') ddl_col FROM DBA_INDEXES i WHERE OWNER = 'MLADEN';
prompt 'Creating Sequences.... '
select dbms_metadata.get_ddl('SEQUENCE',s.sequence_name,'MLADEN') ddl_col FROM DBA_SEQUENCES s WHERE SEQUENCE_OWNER = 'M LADEN';
prompt 'Creating Views.... '
select dbms_metadata.get_ddl('VIEW',v.view_name,'MLADEN') ddl_col FROM DBA_VIEWS v WHERE OWNER = 'MLADEN';
prompt 'Creating Materialized Views.... ' select dbms_metadata.get_ddl('MATERIALIZED_VIEW',mv.mview_name,'MLADEN') ddl_col FROM DBA_MVIEWS mv WHERE OWNER = 'MLADE N';
prompt 'Creating Types.... '
select dbms_metadata.get_ddl('TYPE',o.object_name,'MLADEN') ddl_col FROM DBA_OBJECTS o WHERE OWNER = 'MLADEN' and object _type='TYPE';
prompt 'Creating Procedures.... '
select dbms_metadata.get_ddl('PROCEDURE',o.object_name,'MLADEN') ddl_col FROM DBA_OBJECTS o WHERE OWNER = 'MLADEN' and o bject_type='PROCEDURE';
prompt 'Creating Functions.... '
select dbms_metadata.get_ddl('FUNCTION',o.object_name,'MLADEN') ddl_col FROM DBA_OBJECTS o WHERE OWNER = 'MLADEN' and ob ject_type='FUNCTION';
prompt 'Creating Packages.... '
select dbms_metadata.get_ddl('PACKAGE',o.object_name,'MLADEN') ddl_col FROM DBA_OBJECTS o WHERE OWNER = 'MLADEN' and obj ect_type='PACKAGE';
prompt 'Creating Triggers.... '
select dbms_metadata.get_ddl('TRIGGER',o.object_name,'MLADEN') ddl_col FROM DBA_OBJECTS o WHERE OWNER = 'MLADEN' and obj ect_type='TRIGGER';
connect system/PASSWORD_at_ORCL
spool off
'Creating User.... '

CREATE USER "MLADEN" IDENTIFIED BY VALUES 'E457C986DE0CEE76' DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
'Creating Role Grants.... '

GRANT "APP_USER" TO "MLADEN";
'Creating System Grants.... '

ERROR:

ORA-31608: specified object of type SYSTEM_GRANT not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 631
ORA-06512: at "SYS.DBMS_METADATA", line 1339
ORA-06512: at line 1


'Creating Object Grants.... '

ERROR:

ORA-31608: specified object of type OBJECT_GRANT not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 631
ORA-06512: at "SYS.DBMS_METADATA", line 1339
ORA-06512: at line 1


'Creating Tables.... '

CREATE TABLE "MLADEN"."T1"
( "C1" NUMBER,
"C2" CLOB
) ;
CREATE UNIQUE INDEX "MLADEN"."PK_T1" ON "MLADEN"."T1" ("C1") ;
ALTER TABLE "MLADEN"."T1" ADD CONSTRAINT "PK_T1" PRIMARY KEY ("C1") ENABLE;
'Creating Indexes.... '

CREATE UNIQUE INDEX "MLADEN"."PK_T1" ON "MLADEN"."T1" ("C1") ;

CREATE UNIQUE INDEX "MLADEN"."SYS_IL0001686010C00002$$" ON "MLADEN"."T1" ( ;

'Creating Sequences.... '
'Creating Views.... '
'Creating Materialized Views.... '
'Creating Types.... '
'Creating Procedures.... '
'Creating Functions.... '
'Creating Packages.... '
'Creating Triggers.... '

Connected.
SQL> SHOW USER
USER is "SYSTEM"
SQL> DROP USER MLADEN;
DROP USER MLADEN
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'MLADEN'

SQL> DROP USER MLADEN CASCADE; User dropped.

SQL>  The above shows that it apparently works for me on 9206 on windows.

On 8/31/05, Gogala, Mladen <MGogala_at_allegientsystems.com> wrote:

> 
> 
> Mark, can you do me a favor and try to extract a definition of a table 
with
> at least one LOB column from 9.2.0.6 <http://9.2.0.6> database using DBMS_METADATA.GET_DDL?
> 
> It doesn't work on Solaris and it doesn't work on Linux. I wonder whether
> the bug was local to those two platforms or global?
> 
> 
> -- 
> Mladen Gogala 
> Ext. 121 
> -----Original Message----- 
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] 
> Sent: Wednesday, August 31, 2005 9:07 AM 
> To: Oracle Discussion List 
> Subject: RE: 10gR2 for solaris (64bit), AIX and HP released 
> 
> 
> >> Special mention of my black list: 
> 9.2.0.6 <http://9.2.0.6> with RAC (first time I had to roleback a 
patchset!).<<
> [rollback] 
> 
> Interesting we have found 9.2.0.6 <http://9.2.0.6> RAC on AIX to be much 
more stable than
> 9.2.0.4 <http://9.2.0.4> or 9.2.0.5 <http://9.2.0.5>. So far (couple months) we have not ran into the
> system hang and crash problems that we suffered from on the lower 
> versions. However, two one-off patches were required prior to going 
> production. The first fixed a slow long on and very slow first run of 
> any query problem. I cannot remember what problem the second patch 
> fixed but both patches were AIX specific with the second being required 
> only for RAC environments. 
> 
> HTH -- Mark D Powell -- 


-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 31 2005 - 10:09:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US