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

Could you explain what is enterprise data warehouse?

1226

What is rank transformation?

1037

Explain pushdown optimization and types in informatica

1122

What are the static cache and dynamic cache in informatica?

1245

How an expression transformation differs from aggregator transformation?

1089

write a query to retrieve the latest records from the table sorted by version(scd)

1122

Explain how many types of dimensions are available in informatica?

1172

How to create the source and target database connections in server manager?

1132

What's the layout of parameter file (what does a parameter file contain?)?

2439

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2780

How to load the data from people soft hrm to people soft erm using informatica?

1067

What is the cumulative sum and moving sum?

1235

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1146

Explain sessions?

1140

How do you load only null records into target? Explain through mapping flow.

2077