how to imp a table, deleting the old data? or deleting the table (before)
suppose: in my actual table tcomven i have 15 records, also suppose, i the file: h12292008.dmp exist 27 records
if i type:
imp UFIERROS/linuxx TABLES=(tcomven) fromuser=UFIERROS touser=UFIERROS file=h12292008.dmp ignore=Y
show that imported 27 records, i checked the table, and i have 15+27 records= 42 Records
my question:
before import the table is possible delte all the content of Tcomven table (note i do it first with sqlpleu and or sqldeveloper) my question is exista flag on the imp command?
or:
if i type (same command without ignore flag):
imp UFIERROS/linuxx TABLES=(tcomven) fromuser=UFIERROS touser=UFIERROS file=h12292008.dmp
say me a error: the object exists, same question: the imp command have a flag for drop first the table tcomven(or in any case, in th exp command)?
thanks