Hi Jonathan,
Oracle 8.1.7.0 on Solaris 2.8 (5.8 or just 8).
It is a private synonym owned by the table owner.
Strange indeed, there is no record of the partition
in dba_segments. All the other partitions show up,
(with the correct owner) and the app is still loading
August data. Where is what I am wondering now?
Sigh ....
All I really need to know is what happens if
I drop the underlying table, the synonym and
recreate the synonym to point to a new table.
Thanks for your assistance.
Dave
> From: "Jonathan Lewis" <[EMAIL PROTECTED]>
> Date: Tue, 7 Aug 2001 20:15:30 +0100
> Subject: Re: PARTITION attache to SYNONYM
>
> Which version of Oracle ?
> I got a 600 error when trying to create a partition
> when using a public synonym instead of the
> table_name on 8.1.7.0
>
> Have a look in dba_segments for segment_name = 'your table name'
> and segment_name = 'your synonym', check especially the OWNER
> in case something very strange has happened.
>
>
> Jonathan Lewis
>
> Seminars on getting the best out of Oracle
> Last few places available for Sept 10th/11th
> See http://www.jlcomp.demon.co.uk/seminar.html
>
>
>
>
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: 07 August 2001 19:57
>
>
> |Hi All,
> | Wondering if anyone has seen anything like this. I have
> |filed a TAR.
> |
> | When adding next month's partition to a table a synonym was
> | used accidently. However, the partition was created and shows
> | up in dba_tab_partitions. However, I cannot modify of drop the
> | partition.
> |
> | ALTER TABLE synonym_name drop PARTITION partition_name;
> | returns no such table
> |
> | ALTER TABLE table_name drop PARTITION partition_name;
> | returns no such partition.
> |
> | I have built another structure to hold the data but does anyone
> | know the consequences if I dorp the ysnonym.
> |
> |TIA
> |Dave
> |
> |
> |--
> |Dave Morgan
> |DBA, Cybersurf
> |Office: 403 777 2000 ext 284
--
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dave Morgan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
