Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


hi all when i am creating repository contents i am getting
this error and not able to create contents please let me
know wht may be the problem
ORA-01031: insufficient privileges

Database driver error...
Function Name : executeDirect
SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT
DISTINCT
DBDNAM DATABASE_NAME,
SRCNAM DEF_SOURCE,
SUBJ_NAME SUBJECT_AREA,
NULL VERSION_ID,
OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER
FROM OPB_DBD, OPB_SUBJECT, OPB_SRC
WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND
OPB_SRC.DBDID = OPB_DBD.DBDID AND
OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND
OPB_SRC.IS_VISIBLE = 1

Oracle Fatal Error
Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
Error occurred while creating the repository
An error has occurred while creating contents. Dropping
repository tables...
Create Contents operation on repository [reposerv] ended at
01/02/2009 13:02:48. Elapsed time is 0:00:09.

Answers were Sorted based on User's Feedback



hi all when i am creating repository contents i am getting this error and not able to create conten..

Answer / ganesh

This error message appears when the user prilliges is not
given. First start the repository service. Then, open the
Admin console, then check repository, integration and
reporting services are running. Then, click on the Domain
name and then give access to the user account by checking
all the above services. Then, restart the computer. Now,
check the repository is running with out error message.

Is This Answer Correct ?    0 Yes 0 No

hi all when i am creating repository contents i am getting this error and not able to create conten..

Answer / chiky

1. login to admin console
2. click your repository
3. goto action delete old data (must)
4. check with db team, your username has DML and DDL
permission. if no, enable them.
5. click on restore content and select your .rep file
6.wait till msg comes successfully restored.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is incremental data aggregation?

3 Answers   IBM,


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


Enlist some properties of sessions.

0 Answers  


wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,


i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  






Enlist few areas or real-time situations where informatica is required.

0 Answers  


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


what is normalizer transformation?

4 Answers   Wipro,


How many number of sessions can one group in batches?

0 Answers  


How many dimensions are there in informatica?

0 Answers  


I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,


How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,






Categories