Re: Import table

"Hans de Ruiter" <hans.ruiter-de_at_siemens.nl> wrote in message news:<a7cbm6$hku_at_thor.siemens.nl>...
> Luca
>
> No. Just make a bat-file/script which 1) drops the table using sqlplus, and
> 2) imports the table.
>
> Hans
>
> "Luca" <lucaudine_at_thotmail.com> wrote in message
> news:9a0m8.6953$pT1.164119_at_news1.tin.it...
> > I want import table and before drop table. Can I do it with command imp?
> >
> >
> > _________________________________________ Luca Mansutti ICQ#:83984964
> > Current ICQ status: SMS: (Send an SMS message to my ICQ): +278314283984964
> > More ways to contact me: http://wwp.icq.com/83984964
> > _________________________________________
> >
> >

[Quoted] Your question is not very clear.If you mean you will like to import before you drop a table(same name).Then you may need to rename the table(use oracle rename command in the database to rename the table),do the import then you can drop your renamed table Michael Tubuo Ngong(Sr DBA) Received on Thu Mar 21 2002 - 20:35:17 CET