Oracle Database Discussions

Hi,

Many times i get a request to load some tables' data from one schema to another . But before doing that i need to compare the structures of the tables in the source & target schema.

How can i do that? The list of tables keep on changing every now & then. In TOAD there is no option to compare a selected list of tables. Comparing the whole schemas is not a option before me as the schemas are too huge and it takes a lot of time to do the schema level comparision.
Note this is a client machine and we are not allowed to install any s/w.


I am working on making a unix script which does that for me. But that may take some time considering the hectic work schedule and my poor knowledge of unix scripting.

Can someone suggest some way to do it?

Regds,
Kunwar