Error Ora-14155 Missing Partition Or Subpartition Keyword
Contents |
went wrong with this rename column statement? If this is your first visit, be sure to check out the FAQ by clicking the link oracle rename table syntax above. You may have to register before you can post: click
Ora 14155 Missing Partition Partitions Subpartition Or Subpartition Keyword
the register link above to proceed. To start viewing messages, select the forum that you want to visit
Rename Table In Oracle 11g
from the selection below. Results 1 to 9 of 9 Thread: What went wrong with this rename column statement? Tweet Thread Tools Show Printable Version Email this Page… Subscribe
Rename Column In Oracle
to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-27-2003,02:51 PM #1 tsaoj View Profile View Forum Posts Junior Member Join Date Oct 2003 Posts 6 What went wrong with this rename column statement? What went wrong with this rename column statement? SQL> ALTER TABLE testrename RENAME PROCESSED to PROCESSED_new; ALTER TABLE testrename RENAME alter table rename column PROCESSED to PROCESSED_new * ERROR at line 1: ORA-14155: missing PARTITION or SUBPARTITION keyword SQL> desc testrename Name Null? Type ----------------------------------------- -------- ---------------------------- SKN NUMBER ASIN VARCHAR2(10) UPC VARCHAR2(20) PRODUCT_NAME VARCHAR2(255) COPY VARCHAR2(2000) AGE_FROM VARCHAR2(25) AGE_TO VARCHAR2(25) BATTERY_INCLUDED VARCHAR2(3) BATTERY_TYPE VARCHAR2(20) BATTERY_AMOUNT VARCHAR2(20) PROCESSED VARCHAR2(1) I am sure the syntex is correct but I kept on getting the same messgage from three databases on 3 versions: 8.1.6, 8.1.7 and 9.2.0. I have renamed columns before and don't remember what I did differently. Could anyone figure out what is the problem here? Thanks. Reply With Quote 10-27-2003,02:59 PM #2 tsaoj View Profile View Forum Posts Junior Member Join Date Oct 2003 Posts 6 Correction to above, this is the statement but still failed: SQL> ALTER TABLE testrename RENAME COLUMN PROCESSED to PROCESSED_new; ALTER TABLE testrename RENAME COLUMN PROCESSED to PROCESSED_new * ERROR at line 1: ORA-14155: missing PARTITION or SUBPARTITION keyword Reply With Quote 10-27-2003,03:06 PM #3 patel_dil View Profile View Forum Posts Senior Member Join Date May 2001 Location Maryland, USA Posts 409 Correct s
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have add column in oracle JavaScript enabled. This tool uses JavaScript ora-00904 and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://www.dbasupport.com/forums/showthread.php?39624-What-went-wrong-with-this-rename-column-statement VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=ORA-14155 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/alter-column-name-problem-why-1211111 SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi in oracle knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Thawte Oracle CloudLock Epicor Software ... View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Development A forum where peers share technical expertise, solve problems, and discuss issues related to Oracle Development. Home | Invite Peers | More Oracle Groups Your account is partition or subpartition ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Alter column name problem, why? Priya Dickshit asked Oct 18, 2006 | Replies (10) Hi, I am facing problem to alter table column name and getting followi ng message ORA-14155: missing PARTITION or SUBPARTITION keyword w hy, but i have the 9i version. Please help me. thanks Priya Join this group Popular White Paper On This Topic 5 Best Practices for Business Intelligence 10Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... venkatesandw replied Oct 18, 2006 hi pr