List Info

Thread: Oracle 9.2.0 Data-dump multiple Schema




Oracle 9.2.0 Data-dump multiple Schema
country flaguser name
United States
2007-08-07 07:30:44
Hello All, 

I tried running "dump-metadata" from my oracle
database (version 9.2.0).

Found that there are multiple schema's already available. 

In the "jdbc.properties.oracle9" file ,
Specifically mentioned the schema
name in which I am interested.

like 
#################snippet from properties file
# For oracle, we should limit the schema to the one of the
user
# Note that Oracle requires this to be uppercase, even when
using delimited
identifiers
ddlutils.schema=MYSCHEMA;
#################snippet end

But when I run the ant task , it not only dump
"MYSCHEMA" but also start
dumping other schema's whcih I don't want , 

So please can anyone tell me how to tackle this issue

Thanks in advance
Regards
-Sanjay

-- 
View this message in context: http://www.nabble.com/Oracl
e-9.2.0-Data-dump-multiple-Schema-tf4229800.html#a12033295
Sent from the Apache DdlUtils - User mailing list archive at
Nabble.com.


Re: Oracle 9.2.0 Data-dump multiple Schema
user name
2007-08-14 00:09:34
On 8/7/07, callme_sanjay <callme_sanjayyahoo.com> wrote:
>
> Hello All,
>
> I tried running "dump-metadata" from my
oracle database (version 9.2.0).
>
> Found that there are multiple schema's already
available.
>
> In the "jdbc.properties.oracle9" file ,
Specifically mentioned the schema
> name in which I am interested.
>
> like
> #################snippet from properties file
> # For oracle, we should limit the schema to the one of
the user
> # Note that Oracle requires this to be uppercase, even
when using delimited
> identifiers
> ddlutils.schema=MYSCHEMA;
> #################snippet end
>
> But when I run the ant task , it not only dump
"MYSCHEMA" but also start
> dumping other schema's whcih I don't want ,
>
> So please can anyone tell me how to tackle this issue

The dump-metadata task is only intended to be used for
debugging
purposes (http://db.apache.org/ddlutils/an
t/org.apache.ddlutils.task.DumpMetadataTask.html).
Likewise, the properties files are used only by the unit
tests.

If you want to run the dump-metadata task, simply supply
parameters to
the Ant task as documented in the above link. You can also
use the
dump-metadata.xml sample Ant build file - if you look into
you'll see
what parameters you can give it, they are all declared as
properties
in the beginning of the file.

Tom

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )