Re: [re-post] import problem

> thanks to everybody,
> in fact my problem was to overwrite the existing triggers and procedures.
> Finally I found the ignore = "Y" option but it takes so much time to load
> the entire db that maybe is better for me to drop the procedures manually
> and then import them.

If you need the code to create your procedures, you can use the SHOW=Y option of the import utility to show the code. Spool the output to a file (or use the LOG parameter) and edit the file to remove the create statements for sequences, tables, indexes, etc. Then you have one script which can be run to create your procedures/triggers/views, etc.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================