ideally tables to be imported shouldn't be in the database, if they exist
anyway, then use ignore=y option to get your work done

ahmed
----- Original Message -----
From: "Lars Baad-Jensen "
<oracledba-ezmlmshield-x69162512.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 31, 2004 2:37 PM
Subject: Import to an existing table


>
> Hi,
> I have a huge table, that i want to make a partition table instead.
>
> I have created the new partitioned table, and i want to import all the
rows from the old table to the new table.
> My problem is, that i takes about 2.5 hours to insert into the new table.
>
> My question is.
> Is it possible to import to an existing table??
>
> I have tried, but a get an error IMP-00015: object already exist
>
> Hope anyone have experienced the same thing, and have an solution
>
> Lars
> Denmark
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page