Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 7918 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
Separate from an archive server and a powerhouse?
Tell me about MD5 functions in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain the different lookup methods used in informatica?
Describe data concatenation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Differentiate between a repository server and a powerhouse?
Mention few power centre client applications with their basic purpose?
What is joiner transformation in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
What all join we can perform in LOOKUP transformation?
How to Create a folder using pmrep command?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
