Hi Godwin
Ok firstly doing a full import will not import SYS, SYSTEM
etc.
How to clean the data there is a couple of other
possibilities, you could have a look at what schemas that you need to import
have data and then use the fromuser and touser functionality to import those to
different schemas as a waypoint and then clean that data.
If you want to merge the data you have into the dev
depending on how much of which database you want to retain you could copy
certain tables to backup tables in your development database truncate all the
tables that will be imported and then import that data and then copy the prior
saved data back and any duplicates will be restored, with teh appropriate
process you could even place teh duplicates into a seperate table if you really
need to.
If you data you have from prod has duplicates I would still
import with fromuser and touser to move it to interim schemas and then run SQL
to remove those duplicates, export that back and reimport it to the correct
schemas.
If you need to find all the schemas then run imp show=y and
this runs a dummy import without actually doing it and will provide you with
what it will attempt to import
HTH
Cheers
Peter
Hi all,
I want to
refresh a production database onto development machine using EXP and IMP. My
prod. database is of very small size of approximately 4GB. I can
get a full backup of the database using EXP by using " exp system/manager
file=exp_full.dmp full=y ignore=y ". My main problem here is that my
development database has already some data and i want to clean all the data
before doing an import from the production, orelse i would be suffering with the
duplication and hell lot of errors with the constraints. I would like to ask you
as what are the different ways i could use to clean the database before a fresh
import. One option would be to drop all the schemas and start the import. In
this scenario, how can i find all the shemas, which does not include the default
schemas that are created at the database creation time. For example: SYS,
SYSTEM, DBSNMP, OUTLN, DIP, TSMSYS are created by default. I do not want to drop
these schemas as it might effect the database. Please advise.
Any information will be of a great help.
Thanks,
Godwin.
