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 is aggregate cache in aggregator transformation?

635

What is a grid in Informatica?

610

Does an informatica transformation support only aggregate expressions?

608

Is it possible to use a client with different version than that of its Informatica server?

645

Why do you use Mapping Parameter and mapping variable?

1288




what is the size of your data warehousing?

1671

How can we improve session performance in aggregator transformation?

674

Write the different tools in the workflow manager?

575

Can we create a Integration service without a Repository service and vice versa?

725

permutations of mapplet

2038

What is meant by query override?

637

What are the advantages of informatica?

572

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10280

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

632

What is union transformation in informatica?

701