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

Which transformation should we use to normalise the COBOL and relational sources?

830

What does reusable transformation mean?

755

what is unit testing?tell me proceedure

1879

What is the way to execute pl/sql script using informatica mapping?

1081

What is sequence generator transformation in informatica?

714




What is exclusive and normal mode for repository services?

794

What is the reusable transformation?

733

In informatics server which files are created during the session rums?

729

server hot-ws270 is connect to Repository B. What does it mean?

1976

How do you convert single row from source into three rows into target?

732

Define the various join types of joiner transformation?

646

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1827

What could be the possible resons of locks by user?

746

Why is sorter an active transformation?

758

What is a node in Informatica?

719