Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: error on table rename

    Has anyone ever seen this :

    I'm connected to an oracle instance (9.2) from a client. i rename a table and execute a query on the client that accesses that table. I get a ora 1003.
    I reconnect and it works fine.

    ideas?

    TIA
    vic

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    try dropping the public synonym for the old tablename.

    drop public synonym oldtablename;
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •