1. login to admin console 2. click your repository 3. goto action delete

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

2 Answers
7814 Views
I also Faced
E-Mail Answers

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

Why do you use Mapping Parameter and mapping variable?

1772

What is informatica etl tool?

1003

How many dimensions are there in informatica?

1096

What is an unconnected transformation?

1090

Differentiate between sessions and batches?

1023

Why do we need informatica?

1002

tell me 5 session failure in real time how can you solve that in your project?

2305

How to update or delete the rows in a target, which do not have key fields?

1181

What are the types of caches in lookup?

1052

what is unit testing?tell me proceedure

2228

How can we create index after completion of load process?

1127

differences between service based and product based?

2020

What are the main issues while working with flat files as source and as targets ?

1167

What is target designer and target load order?

1111

Suppose we do not group by on any ports of the aggregator what will be the output?

1046