Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitions to non-partition
This was a no-go...
But I already had the scripts from TOAD, and I had in advance edited them to make sure it ONLY created the partition that I wanted, where I wanted it. So I ran the scripts and the data is going in now. This time it looks good.
Thanks for the help.
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf
> Of Darrell Landrum
> Sent: Thursday, August 12, 2004 8:25 PM
> To: oracle-l_at_freelists.org
> Subject: Re: Partitions to non-partition
>
> Michael, you don't mention which database version (and it may not
matter),
> but what you describe is entirely possible. I've done it on 9.2.0.4.
You
> may need to use "ignore=Y" to avoid warnings, but the data can still
get
> safely from partitioned table to non-partitioned table.
>
>
> ----- Original Message -----
> From: "Kline.Michael" <Michael.Kline_at_SunTrust.com>
> To: <oracle-l_at_freelists.org>
> Sent: Thursday, August 12, 2004 3:01 PM
> Subject: Partitions to non-partition
>
>
> > I've got data in one database that's not allowed to be touched for
now,
> > but I would like to get it out and take it to another database where
the
> > same table is NOT partitioned.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Aug 13 2004 - 13:19:33 CDT
![]() |
![]() |