If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

exp/imp 9i overwrite

hi,
newby question re exp/imp
If we do an exp full=y
and want to import the data into another instance and overwite the data, what do we do?
If I just do a straight import, presumably entries will not be overwritten? - so do existing objects not get re-created either, and just left alone?
and if I do not say ignore=y will it fail?
I basically want to overwrite the existing data in the schema to imp into - can I do that easily?

and if I only want to import data for one user, and leave the rest alone, but I still want to overwrite the data for that one user, then how do I do it?
Someone told me not to use destroy=y - it is not strictly used to overwrite the data, but will get rid of the actual existing datafiles and can leave you in the lurch (so to speak)?
I am a litle confused as to what destroy=y means - obviosuly in my case I only want to overwrite the one user on the database, not all of them, and presumably the datafile would be in use by many users, therfore if I destroed it, would end up losing the data for the other exisiting users?
or do I have it all wrong?