1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / chiky

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of transformation available in informatica.

620

What is the cumulative sum and moving sum?

741

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5551

Write the advantages of partitioning a session?

737

What are the types of presistent cache in look up tr.

1535




Target increases every day even though no new record was inserted

1098

What is flashback table ? Advance thanks

1473

What is an active transformation?

636

Write the unconnected lookup syntax and how to return more than one column.

585

What is a repository? And how to add it in an informatica client?

638

what is SDLC way of code development?

1548

How to load last n records of file into target table - informatica

587

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1546

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1722

What do you understand by SOA of Informatica?

576