To use those .sql insert statement files where we want across different release/Regions ( dev/ Ist/...)
This will be Static data .

Since we don't have to engage DBA time by asking him to exp/ Imp always.

To use those .sql insert statement files where we want across different release/Regions ( dev/ Ist/...)
This will be Static data .

Since we don't have to engage DBA time by asking him to exp/ Imp always.

If there is a way that will help us,

Thanks for looking into it

cookiemonster, not all companies work the same way. For example, my company has for many years been tightening access to all its oracle databases. This always translates into less capability for everyone. As an example, I have no access to exp/imp or datapump. Indeed, no access to any database server tools.

Indeed, this is actually getting quite common. I would even go so far as to say that most people who work with Oracle, do not have this access anymore. Think of it like this:

for many developers, if you can't do it from windows, you can't do it.

So... how would a developer run exp/imp from windows against a database installed on a restricted access Unix server? The developer is not allowed direct access to the database server.

Of course this does bring up a question... why does the OP need to do what they are asking? Is this for a production job? If so then maybe they should be given more privileges for it, or put in touch with other developers that have access to the necessary locations and tools.