Re: PARTITION attache to SYNONYM

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" <jonathan_at_jlcomp.demon.co.uk>
> 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 <ORACLE-L_at_fatcity.com>
> 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: dave.morgan_at_cybersurf.net

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: ListGuru_at_fatcity.com (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).