ORACLE: ORA-01130

During the process of cloning this error may cause a lot of agony.

Solution: In your Init.ora file add the compatibility level using the following.

compatible='10.2.0.3.0'
However, before setting the compatibility level of you clone, check
the source database compatibility using the following views.
SQL> col status for a6
SQL> col version for a10
SQL> col comp_name for a35
SQL> set lines 150
SQL> set pages 100
select  comp_name, version, status,modified from dba_registry;

COMP_NAME                           VERSION    STATUS MODIFIED
----------------------------------- ---------- ------ --------------------
Oracle Enterprise Manager           10.2.0.3.0 VALID  17-APR-2007 04:49:57
Spatial                             10.2.0.3.0 VALID  18-JUN-2011 16:02:56
Oracle interMedia                   10.2.0.3.0 VALID  18-JUN-2011 16:02:55
OLAP Catalog                        10.2.0.3.0 VALID  18-JUN-2011 16:02:56
Oracle XML Database                 10.2.0.3.0 VALID  18-JUN-2011 16:02:55
Oracle Text                         10.2.0.3.0 VALID  18-JUN-2011 16:02:51
Oracle Expression Filter            10.2.0.3.0 VALID  18-JUN-2011 16:02:51
Oracle Rules Manager                10.2.0.3.0 VALID  18-JUN-2011 16:02:55
Oracle Workspace Manager            10.2.0.1.0 VALID  18-JUN-2011 16:02:50
Oracle Data Mining                  10.2.0.3.0 VALID  18-JUN-2011 16:02:51
Oracle Database Catalog Views       10.2.0.3.0 VALID  18-JUN-2011 16:02:50
Oracle Database Packages and Types  10.2.0.3.0 VALID  18-JUN-2011 16:02:50
JServer JAVA Virtual Machine        10.2.0.3.0 VALID  18-JUN-2011 16:02:51
Oracle XDK                          10.2.0.3.0 VALID  18-JUN-2011 16:02:51
Oracle Database Java Packages       10.2.0.3.0 VALID  18-JUN-2011 16:02:51
OLAP Analytic Workspace             10.2.0.3.0 VALID  18-JUN-2011 16:02:55
Oracle OLAP API                     10.2.0.3.0 VALID  18-JUN-2011 16:02:55

17 rows selected.



SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production