GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 214 of 301    Print  
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option error in Informatica
I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing the expected ,while executing in PL/SQL.

The output of this proc comes like this
ALTER INDEX MODIFY PARTITION < PARTITION_NAME> UNUSABLE

Is there any specific syntax for executing alter index option through informatica?



  
Total Answers and Comments: 0 Last Update: September 03, 2007     Asked by: ravi 
  
 Sponsored Links

 

No answers are posted for this question yet.
Be the first to answer it!


 Related Questions

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh
Read Answers (48) | Asked by : nagesh

Latest Answer : There are two types1.GDR and LDR2.Versioned and NonVersionedWe can use them in combinations, meaningGDR [Versioned/Non Versioned[Default]]LDR [Versioned/Non Versioned[Default] ...

Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita.
Read Answers (3) | Asked by : Arpita

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.i hav windows server 2003 OSPlease, any one have a solution to this problem

The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Read Answers (4) | Asked by : Deshaireddy

Latest Answer : No GUI mode for informatica in unix. In Unix you cannot design the mappings and workflow as you do in windows. Unix operating sys can only be used to run the jobs, schudule it... Sidhu ...

Can any body tell me the configuration of informatica in UNIX, or if it is lenghty pls send the doc. thanks in advance

What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah
Read Answers (2) | Asked by : Deborah

Hi all,I am getting the following message when I start theinfa Repository server ..Could not start INFORMATICA Repository SERVER on Local ComputerERROR 1053 : the service did not respond to the start or control request in a timely fashionThis is the first time I found the above problem.Could you plz let me know what might be the reason ..Environment : Win sever 2003 , Oracle 9i and Infa 7.1.1.Thanks in Advance ..Thanks,Priya
Read Answers (2) | Asked by : priya...

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
Read Answers (4) | Asked by : pratyusha


 Sponsored Links

 
Related Articles

What is Bit Mapped Index

Bit Map Indexing is a technique commonly used in relational databases where the application uses binary coding in representing data. This technique was originally used for low cardinality data but recent applications like the Sybase IQ have used this technique efficiently. The word cardinality is
 

What is the use of COUNT with DISTINCT option

COUNT is a group function returns&nbsp;result by summarizing multiple rows. All group by value function will have the usage of DISTINCT or ALL option and so is the COUNT which uses the DISTINCT option. DISTINCT option is used to enforce uniqueness and&nbsp; if combined with COUNT is used to
 

Finding The Right Student Loan Option

Finding The Right Student Loan Option Finding the right student loan can be a struggle to many students It is one major decision that can make or break a student&rsquo; s future financial stability If you make the mistake of getting a student loan that you cannot properly manage as you go along
 

The Use of Trial and Error To Solve Problems

The Use of Trial and Error To Solve Problems Some complex problems can be solved by a technique that is called trial and error Trial and error is typically good for problems where you have multiple chances to get the correct solution However this is not a good technique for problems that don t give
 

WebSphere V5.0 : Web Development - Use Page Designer to add and modify HTML and JSP content

WebSphere V5 0 Web Development Use Page Designer to add and modify HTML and JSP content including the use of JavaScript In this tutorial you will learn about WebSphere V5 0 Web Development Use Page Designer to add and modify HTML and JSP content including the use of JavaScript Page Designer Working
 

Oracle 10g Tutorials -Creating Index-Organized Tables

Oracle 10g Free Training Creating Index Organized Tables Let us learn about Creating Index Organized Tables by Creating an Index Organized Table further by Creating Index Organized Tables that Contain Object Types and also you will learn how to View Information about Tables mosgoogle Creating Index
 

Better System Error Reporting using Websphere

System errors are unexpected and usually cause unrecoverable damage to a transaction Examples of system error are file system out of space out of memory exception and database connection timeout mosgoogle Click here for the article Category Weblogic
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape