users@glassfish.java.net

capture-schema utility not working

From: <glassfish_at_javadesktop.org>
Date: Thu, 11 Feb 2010 17:15:06 PST

Hi, I try to use capture-schema to generate .dbschema file. The script finish very fast with no error but the generated file is very short and it's different from the auto generated .dbschema at deployment time. I think it's not really accessing the schema. So could anyone point out to me what I did wrong?

I use oracle database. The way my oracle schema being setup up is that the the schema directly tied to the user's name. I am not sure how capture-schema utility access the oracle schema through its argument -schemaname. Is it the same as the DEFAULT_TABLESPACE column in dba_users?

I also tried to pass in -table argument with valid table name, and it will give "Cannot access table .." error. So it further proves that it's not accessing the schema correctly.

Thank you in advance for your help.

Michelle
[Message sent by forum member 'mwei' (mxue_at_myproductadvisor.com)]

http://forums.java.net/jive/thread.jspa?messageID=386274