Refreshing the database

[ghanshyamkhetan]

Hi All,

Is it possible instead of full database cloning only one schema like gl, ap as required by developers will refreshed through export import utility.
Will it work or not.
Because is for only one or two module like FA, GL we have to go for full cloning. If it possible please suggest.

Thanks
Ghanshyam

[mully31]

What version of db are you using? if before 10g, then you can use the exp fromuser touser option.
if 10g and above, use expdb.
All the syntax is in oracle docs


cheers
Mark