Look at the table name in the user_tables vielw is it mixed case? How
was this table created?
If name is in mixed case oracle will not see it as a valid one.
Need to put " around table name and this should work
--------
Andy Winningham
Senior Technical consultant
Accela, Inc.
1731 W. Walnut
Visalia
CA, 93277
Tel: 559 627 1959, ext 149
Fax: 559 627-0660
Cel: 559 901-6062
www.accela.com <http://www.accela.com
SAVE THE DATE: Accela User Conference | August 4 - 7, 2008 | Las Vegas,
NV | www.accela.com/uc08
-----Original Message-----
From: Luis Cardenas
[mailto:oracledba-ezmlmshield-x19091553.[Email address protected]
Sent: Wednesday, March 05, 2008 8:07 AM
To: LazyDBA Discussion
Subject: rename table question
I am getting an error when attempting to rename a table as follows:
rename table ATD_UK_PAF.FLATFILE_OLD to ATD_UK_PAF.FLATFILE_NEW
*
ERROR at line 1:
ORA-00903: invalid table name
Can any one spot the reason? I am logged on with user holding the DBA
belt!
Thanks
Luis Cardenas
Database Administrator
Trader Media Ltd
t: +44 (0) 1925 296221
e. luis.[Email address protected]
-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited, registered
office: Unit 6, Thatcham Business Village, Colthrop Lane, Thatcham,
Berkshire RG19 4LW (Registered in England No.
4768833). This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender. This email message has been swept for the presence of
computer viruses. www.ciphertrust.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page