The code behind capture-schema and auto-capturing is the same. The user
name is converted to upper case and used as the schema name.
Try specifying the table names in caps.
HTH,
-marina
glassfish_at_javadesktop.org wrote:
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>