Installing iAS 10.1.3.3 on CENTOS 5

Yes it works no problem; When selecting what bits of CentOS to install, select Server.

Then use the Metalink Note for RHEL5 564174.1 ; you will need an old libdb library as well because Apache will not start without it; Do not do as I did and try and find an ancient compat-db - instead read the above note and get the library from Metalink.


Of course you should immediately patch to 10.1.3.4 as well.

More later.

generating all tablespace ddl from a database

So if you want to get the DDL for tablespaces :


SQL*Plus: Release 10.2.0.4.0 - Production on Fri Sep 12 16:40:54 2008

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set long 32000
SQL> set linesize 32000
SQL> set pagesize 0

SQL> exec dbms_metadata.set_transform_param( DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true);

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('TABLESPACE',tbs.tablespace_name) from dba_tablespaces tbs;


spool it to a file

et voila