Giter VIP home page Giter VIP logo

oracle-ddl2svn's Introduction

Set of tools for automatization storing of oracle DDL schema in SVN.

The contents of the set

  1. scheme2ddl - command line utility for export oracle schema in set of ddl scripts. provide lot of configurations via basic command line options or advanced XML configuration
  2. additional scripts (sh, bat and ant) for automated retrieving scheme ddl and storing it in svn

Benefits

Using of SVN (or other VCS tools) for storing changes of oracle scheme is great idea. Simple scenario as 2-step script

exp user/password@sid owner=owner file=file.dmp log=logfile.log rows=n
imp user/password@sid full=y file=file.dmp show=y log=script.log

is work, but outbut is ugly formatted scripts in one file, with lot of additional information.

scheme2ddl give ability to filter undesirable information, separate DDL in different files, pretty format output.

How to start with minimal configuration

Java must be installed on your computer. For exporting oracle scheme you must provide

  • DB connection string
  • output directory Usage example. Command
java -jar scheme2ddl.jar -url scott/tiger@localhost:1521:ORCL -o C:/temp/oracle-ddl2svn/

will produce directory tree

 views/
       view1.sql
       view2.sql
 tables/
       table1.sql
 functions
      /f1.sql  

More command line options

java -jar scheme2ddl.jar -help

How it is work inside?

  1. First, get list of all user_object to export
select * from user_objects where object_type in ()
  1. then applying dbms_metadata.set_transform_param
  2. for every user object invoke dbms_metadata.get_ddl and dbms_metadata.get_dependent_ddl
  3. print every ddl to separate file grouped in folders like tables, views, procedures etc

Advanced configuration

advanced configuration provided in scheme2ddl.config.xml,

oracle-ddl2svn's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar

oracle-ddl2svn's Issues

file names in lower case

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 28 Feb 2011 at 3:00

Add include and exlude filters

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 10 May 2011 at 10:23

add support for git

add support for git

@echo off
rem DESCRIPTION
rem two-step script
rem 1) get DDLs from oracle schema
rem 2) auto-commit DDLs in SVN

rem REQUREMENTS
rem java must be installed
rem svn console client must be installed
rem output dir must be under version control in svn

rem SET PARAMETERS
rem first parameter is DB_URL
rem second parameter is OUTPUT_DIR
rem you can overwrite this parameters
set DB_URL=
set OUTPUT_DIR=
set GIT_BRANCH=autotrack_TEST2
set COMMIT_MESSAGE="automatic commit by oracle-ddl2git"

set WORKING_DIR=%cd%

rem test db connection,
rem if db connect is fail, do not perform any filesystem operation, only clean tmp file end exit
echo =========  start of test db connection %date% %time% ==============
set tempfile=connection.tmp
del %tempfile%
java -jar scheme2ddl.jar --test-connection -url %DB_URL% > %tempfile% 2>&1
find "FAIL connect to" %tempfile%
if not errorlevel 1 goto :exit

:runScript
rem delete all files from output directory exept system files
rem this command must keep on disk svn meta information stored in .svn folders
echo =========  start of scheme2ddl %date% %time% ==============
cd %OUTPUT_DIR%
git checkout %GIT_BRANCH%
git clean -f -d
git rm -rf .
git -c core.quotepath=false checkout HEAD -- .tgitconfig .gitignore
cd %WORKING_DIR%
java -jar scheme2ddl.jar -url %DB_URL% -output %OUTPUT_DIR% -c scheme2ddl.config.xml
echo =========  end of scheme2ddl %date% %time% ==============

cd %OUTPUT_DIR%
git add -A
git commit -m %COMMIT_MESSAGE%
git push

:exit
cd %WORKING_DIR%
del %tempfile%

Add --parallel option


Add --parallel %integer% option 
Default: 1

Specifies the maximum number of threads of active execution operating.
This parameter enables you to make trade-offs between resource consumption and 
elapsed time.

Original issue reported on code.google.com by [email protected] on 21 Jul 2012 at 5:41

PUBLIC DB_LINKS

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 1 Nov 2011 at 10:20

invoking DBMS_METADATA.SET_TRANSFORM_PARAM fails on oracle 10g

What steps will reproduce the problem?
1. build from
Revision: 146
Author: wallyatkins
Message:
Updated transform params a little. It looks like there should not be an auto 
commit on these calls and Oracle 11g uses TRUE and FALSE instead of 1 and 0.
----
Modified : /trunk/scheme2ddl/src/ru/qwazer/scheme2ddl/Dao.java

2. run againist oracle 10g
3. got error

Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: 
ConnectionCallback; bad SQL grammar []; nested exception is 
java.sql.SQLException: ORA-06553: PLS-221: 'SESSION_TRANSFORM' is not a 
procedure or is undefined

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)
    at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Dao.java:59)
    at ru.qwazer.scheme2ddl.Dao.fillDDL(Dao.java:46)
    at ru.qwazer.scheme2ddl.Worker.work(Worker.java:39)
    at ru.qwazer.scheme2ddl.Main.main(Main.java:59)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)
Caused by: java.sql.SQLException: ORA-06553: PLS-221: 'SESSION_TRANSFORM' is 
not a procedure or is undefined



Original issue reported on code.google.com by [email protected] on 9 Jun 2011 at 5:53

DDL_Get fails on queue object

What steps will reproduce the problem?
execute the ddl2svn against an Oracle database that has queues defined

What do you see instead?
I see the that "Queue" is invalid object type for GET_DDL Oracle function.

What version of the product are you using? On what operating system?
Oracle 11.2.0.3.0 - 64 bit, Windows Server 2008 R2 Standard

I got a copy of the ddl2svn code and modified the sql code for handling queue 
objects.

Original issue reported on code.google.com by [email protected] on 3 Oct 2014 at 9:37

ORA-31600: invalid input value PACKAGE BODY for parameter OBJECT_TYPE in function GET_DDL

INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
ConnectionCallback; uncategorized SQLException for SQL []; SQL state [99999]; 
error code [31600]; ORA-31600: invalid input value PACKAGE BODY for parameter 
OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2682
ORA-06512: at "SYS.DBMS_METADATA", line 2733
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1


Original issue reported on code.google.com by [email protected] on 28 Feb 2011 at 1:20

11g - ORA-31600: invalid input value string for parameter string in function stri

1) 
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

java -jar scheme2ddl.jar -url user/user@server -o server

ok

2) 
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production

java -jar scheme2ddl.jar -url user/user@server -o server

error
; nested exception is java.sql.SQLException: ORA-31600: 
недопустимое входное значение 0 параметра 
SEGMENT_ATTRIBUTES в функции SET_TRANSFORM_PARAM
ORA-06512: на  "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: на  "SYS.DBMS_METADATA_INT", line 8330
ORA-06512: на  "SYS.DBMS_METADATA_INT", line 9667
ORA-06512: на  "SYS.DBMS_METADATA", line 4865
ORA-06512: на  line 1



Original issue reported on code.google.com by [email protected] on 21 Oct 2011 at 6:46

Attachments:

folder names in plural

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 28 Feb 2011 at 3:00

JAVA_SOURCE DB_LINK

scheme2ddl.config.xml

add
    <bean id="dao" class="ru.qwazer.scheme2ddl.Dao">
        <property name="map">
            <map>
                <entry key="JAVA_SOURCE">
                    <set>
                        <value>OBJECT_GRANT</value>
                    </set>
                </entry>
                <entry key="DB_LINK">
                    <set>
                        <value>OBJECT_GRANT</value>
                    </set>
                </entry>


and
    <util:set id="types_for_getting_DDL">
        <value>JAVA_SOURCE</value>
        <value>DB_LINK</value>

not export JAVA_SOURCE and DB_LINK
why?

Original issue reported on code.google.com by [email protected] on 21 Oct 2011 at 7:28

Attachments:

BadSqlGrammarException in REFRESH GROUP

[java] Encountered an error executing the step
[14:11:00][java] org.springframework.jdbc.BadSqlGrammarException: 
StatementCallback; bad SQL grammar [select t.object_name, t.object_type   from 
user_objects t  where t.generated = 'N'    and not exists (select 1           
from user_nested_tables unt         where t.object_name = unt.table_name) UNION 
ALL  select rname, 'REFRESH GROUP', NULL  from user_refresh a ]; nested 
exception is java.sql.SQLException: ORA-01789: query block has incorrect number 
of result columns
[14:11:00][java]

Original issue reported on code.google.com by [email protected] on 30 Apr 2013 at 10:13

Error exporting DDL from Oracle 11g

What steps will reproduce the problem?
1. Run oracle-ddl2svn v1.3 against Oracle 11gR2 instance

What is the expected output? What do you see instead?

Expected to get schema SQL file output but an error occurs after successfully 
connecting to the Oracle instance.

What version of the product are you using? On what operating system?

Using oracle-ddl2svn v1.3 on RHEL5 against an Oracle 11gR2 instance.

Please provide any additional information below.

Here is the error that I receive from executing the JAR:

$ java -jar scheme2ddl.jar -url user/pass@localhost:1521:ORCL -o /tmp/test/

...

ORA-31600: invalid input value 0 for parameter SEGMENT_ATTRIBUTES in function 
SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 8330
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9667
ORA-06512: at "SYS.DBMS_METADATA", line 4865
ORA-06512: at line 1

Original issue reported on code.google.com by wallyatkins on 8 Jun 2011 at 2:24

Allow user to specify the Oracle JDBC client

What steps will reproduce the problem?
1. Run oracle-ddl2svn against an Oracle instance that has been run through the 
US DoD Security Technical Implementation Guide for Oracle

What is the expected output? What do you see instead?

Instead of connecting to the database to initiate the creation of the DDL for 
the specified schema an ORA-28040 exception is thrown. (No matching 
authentication protocol)

What version of the product are you using? On what operating system?

Using oracle-ddl2svn v1.2 on RHEL 5 and connecting to an Oracle 11gR2 instance.

Please provide any additional information below.

In our environment the Oracle client connecting to the Oracle DB must match the 
version in order to follow the rules of security and information assurance. 
Bundling the Oracle JDBC client JAR might actually be against Oracle's terms of 
use and, in this case, it makes it harder to use your utility. You may want to 
consider allowing the user to specify the path to their local Oracle client 
JAR. 


Original issue reported on code.google.com by wallyatkins on 7 Jun 2011 at 2:33

exlude system types

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 22 Mar 2011 at 12:58

Stop ddl2svn if exception in sheme2ddl

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 29 Aug 2012 at 9:38

More verbose error logging

If processing of taskitem fail, scheme2ddl must provide info about failed 
taskitem ( object type and name)

Original issue reported on code.google.com by [email protected] on 16 Apr 2013 at 6:22

ORA-31603: объект "SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме

oracle-ddl2svn-v1.5.1
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production

Export PACKAGE with TYPE 

CREATE OR REPLACE PACKAGE PKG_SPB AS
    TYPE tViewRow   IS RECORD(
                                id NUMBER(38),
                                id_parent NUMBER(38),
                                name VARCHAR2(1024),
                                is_leaf NUMBER(1));
    TYPE tViewTable IS TABLE OF tViewRow;    
END PKG_SPB; 

Exeption 

19.07.2012 19:02:34 
org.springframework.beans.factory.xml.XmlBeanDefinitionReader 
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource 
[org/springframework/jdbc/support/sql-error-codes.xml]
19.07.2012 19:02:34 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
ConnectionCallback; uncategorized SQLException for SQL []; SQL state [99999]; 
error code [31603]; ORA-31603: объект "SYS_PLSQL_77728_DUMMY_1" с 
типом TYPE не найден в схеме "SP_MAIN"
ORA-06512: на  "SYS.DBMS_METADATA", line 4018
ORA-06512: на  "SYS.DBMS_METADATA", line 5843
ORA-06512: на  line 1
; nested exception is java.sql.SQLException: ORA-31603: объект 
"SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме 
"SP_MAIN"
ORA-06512: на  "SYS.DBMS_METADATA", line 4018
ORA-06512: на  "SYS.DBMS_METADATA", line 5843
ORA-06512: на  line 1

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)
    at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Unknown Source)
    at ru.qwazer.scheme2ddl.Dao.fillDDL(Unknown Source)
    at ru.qwazer.scheme2ddl.Worker.work(Unknown Source)
    at ru.qwazer.scheme2ddl.Main.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-31603: объект 
"SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме 
"SP_MAIN"
ORA-06512: на  "SYS.DBMS_METADATA", line 4018
ORA-06512: на  "SYS.DBMS_METADATA", line 5843
ORA-06512: на  line 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1185)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
    at ru.qwazer.scheme2ddl.Dao$1.doInConnection(Unknown Source)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
    ... 4 more


Original issue reported on code.google.com by [email protected] on 20 Jul 2012 at 1:56

ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL


Participationed table support missing?

What do you see instead?

Encountered an error executing the step
org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state [99999]; error code [31600]; 
ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in 
function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3025
ORA-06512: at "SYS.DBMS_METADATA", line 3076
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31600: invalid input value 
TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3025
ORA-06512: at "SYS.DBMS_METADATA", line 3076
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1


What version of the product are you using? On what operating system?

$ java -jar scheme2ddl.jar -version
scheme2ddl version 2.0.1
$ java -version
java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

Original issue reported on code.google.com by [email protected] on 12 Dec 2012 at 2:54

Mavenize project

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 22 Sep 2011 at 12:33

Exception in thread "main" java.util.zip.ZipException: ═х єфрхЄё  эрщЄш єърчрээ√ щ Їрщы

when I try run java -jar scheme2ddl -help

I get error 
Exception in thread "main" java.util.zip.ZipException: ═х єфрхЄё  
эрщЄш єърчрээ√
щ Їрщы
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)

What do I do wrong?


Original issue reported on code.google.com by [email protected] on 23 Jan 2012 at 12:28

filenames with / produde error

saved NTT_VARCHAR2 to file D:/temp/oracle-ddl2svn/TYPE/NTT_VARCHAR2.sql
.java.io.FileNotFoundException: 
D:\temp\oracle-ddl2svn\TYPE\SYSTPnHq\ti7oMMzgQwoBitAwzA==.sql (Системе 
не удается найти указанный путь)
    at java.io.FileOutputStream.open(Native Method)

Original issue reported on code.google.com by [email protected] on 28 Feb 2011 at 2:55

export db links

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 14 Sep 2011 at 12:28

mat view not deleted in batch

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 16 Apr 2011 at 2:00

Fix manifext.mf issue svn.url

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.


Original issue reported on code.google.com by [email protected] on 16 Mar 2011 at 3:06

java.sql.SQLException: ORA-23421 dbms_job.user_export(101, callstr)

INFO: Loading XML bean definitions from file 
[/home/pimenov_pa/sql/scheme2ddl.config.xml]
08.11.2012 9:48:53 
org.springframework.beans.factory.support.DefaultListableBeanFactory 
preInstantiateSingletons
INFO: Pre-instantiating singletons in 
org.springframework.beans.factory.support.DefaultListableBeanFactory@4e044e04: 
defining beans [dataSource,dao,ty
pes_for_getting_DDL,exclude_map_prefixes,exclude_map_pattern,fileWorker,transfor
mParams_for_dbms_metadata,ddlFormatter,worker]; root of factory hierar
chy
start getting of user object list for processing
list.size() before filter = 60
get 60 objects
08.11.2012 9:48:54 
org.springframework.beans.factory.xml.XmlBeanDefinitionReader 
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource 
[org/springframework/jdbc/support/sql-error-codes.xml]
08.11.2012 9:48:54 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
CallableStatementCallback; uncategorized SQLException for SQL [DECLARE
 callstr VARCHAR2(4000);
BEGIN
  dbms_job.user_export(101, callstr);
:done := callstr; END;]; SQL state [99999]; error code [23421]; ORA-23421: 
íîìåð çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â 
î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4
; nested exception is java.sql.SQLException: ORA-23421: íîìåð 
çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â 
î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:944)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:956)
        at ru.qwazer.scheme2ddl.Dao.findDbmsJobDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Dao.fillDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Worker.work(Unknown Source)
        at ru.qwazer.scheme2ddl.Main.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-23421: íîìåð çàäàíèÿ 101 íå 
ñîîòâåòñòâóåò çàäàíèþ â î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
        at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4719)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
        at ru.qwazer.scheme2ddl.Dao$CallableStatementCallbackImpl.doInCallableStatement(Unknown Source)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:928)
        ... 6 more

Original issue reported on code.google.com by [email protected] on 8 Nov 2012 at 5:54

ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL

Hello,
I have a problem with a schema export. I gives me the error:



Encountered an error executing the step
org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state [99999]; error code [31600];
ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3130
ORA-06512: at "SYS.DBMS_METADATA", line 3185
ORA-06512: at "SYS.DBMS_METADATA", line 4863
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31600: invalid input value LOB 
for parameter OBJECT_TYPE in function GET_DDL


Version of scheme2ddl is 2.0.2, the same server as before when it was a 
successfull export bot on another schema. I used sys as sysdba for connect and 
a single schema in the schema list.

Previously the message was: Saved [...] ....   (a successfull save). But it 
doesn't say what is the current object that the will get the ddl from, in order 
to see what is the object with the problem when it creashes....

The log should be like:

Saving [...] ....       [done]

and [done] should be added after a sucessful save. In case it crashes, on the 
screen will remain the last object it was working on.

Do you have any ideea from this log what is the problem ?

Best regards!

Original issue reported on code.google.com by [email protected] on 16 Apr 2013 at 2:59

ORA-31603: object "XXXXX" of type DB_LINK not found in schema "PUBLIC"


org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state
 [99999]; error code [31603]; ORA-31603: object "XXXXX" of type DB_LINK not found in schema "PUBLIC"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 628
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31603: object "XXXXX" of type 
DB_LINK not found in sche
ma "PUBLIC"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 628
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

Not sure, but you probably need to map to "DATABASE LINK" (at least that's how 
it's listed in the _OBJECTS views.

Related, is there a way to exclude database links? As this depends on 
privileges on DBA_DB_LINKS view which the user may not have...

scheme2ddl version 2.0.1

Original issue reported on code.google.com by [email protected] on 13 Dec 2012 at 12:11

exclude_map_suffixes

Hi, 

in the current version of the project it is possible to exclude objects with a 
certain prefix, using the exclude_map_prefixes. Could you also add the option 
to exclude objects with a certain suffix?


thanks for the good work.



regards,
John

Original issue reported on code.google.com by [email protected] on 19 Apr 2012 at 7:58

Error on exporting nested tables.

> What steps will reproduce the problem?
  Export schema containing nested table(s).

> What is the expected output? What do you see instead?
  Raised exception: ORA-31603: object "..." of type TABLE not found in schema "..."

> What version of the product are you using? On what operating system?
  1.4, Oracle 10.2.0.3

> Please provide any additional information below.
  "select * from user_objects" return for this object object_type='TABLE', but "dbms_metadata.get_ddl(object_type => 'TABLE', name => '...', schema => '...')" raises exception ORA-31603.

  Master table was exported successfully with resulting script like:
    CREATE TABLE "<schema>"."<master_table>" 
     ("<some_field>" NUMBER NOT NULL ENABLE, 
      ... 
      "<nested_table_field>" "<schema>"."<nested_table_type>" 
     ) 
     NESTED TABLE "<nested_table_field>" STORE AS "<nested_table>";

  Then exp. <nested_table> failed.

Original issue reported on code.google.com by [email protected] on 6 Sep 2011 at 9:57

ORA-31600: invalid input value PACKAGE BODY for parameter OBJECT_TYPE in function GET_DDL

INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
ConnectionCallback; uncategorized SQLException for SQL []; SQL state [99999]; 
error code [31600]; ORA-31600: invalid input value PACKAGE BODY for parameter 
OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2682
ORA-06512: at "SYS.DBMS_METADATA", line 2733
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1


Original issue reported on code.google.com by [email protected] on 28 Feb 2011 at 1:20

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.