Your rename syntax is wrong
SQL> rename <old_table_name> to <new_table_name>;
In your query "remove" table keyword after "rename" keyword
Regards,
Siva.P
Bangalore
-----Original Message-----
From: Luis Cardenas
[mailto:oracledba-ezmlmshield-x19091553.[Email address protected]
Sent: Wednesday, March 05, 2008 9:37 PM
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
***********************
No virus was detected in the attachment no filename
Your mail has been scanned by InterScan.
***********-***********
*********************************************************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may contain Birlasoft confidential or privileged information. If you are not the intended recipient,any disclosure,copying, use, or distribution of the information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify us by reply e-mail at ([Email address protected] and permanently delete this message and any attachments. Thank you."
*********************************************************************************************************************************************************************
Oracle LazyDBA home page