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
7773 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

How identifying bottlenecks in various components of informatica and resolving them?

1113

How do you load first and last records into target table?

1149

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2045

what is mean by complex business rule ?

2148

Explain the scenario which compels informatica server to reject files?

1151

difference between informatica 8.1.1 and 8.6

3664

What are the conditions needed to improve the performance of informatica aggregator transformation?

1081

How can we create index after completion of load process?

1111

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

1971

Whats the difference between informatica powercenter server, repositoryserver and repository?

1166

What are session parameters ? How do you set them?

1833

What are the settings that you use to configure the joiner transformation?

1045

What is a joiner transformation and why it is an active one?

1065

design of staging area?

2020

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

1125