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
- 7148 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
This error message appears when the user prilliges is not
given. First start the repository service. Then, open the
Admin console, then check repository, integration and
reporting services are running. Then, click on the Domain
name and then give access to the user account by checking
all the above services. Then, restart the computer. Now,
check the repository is running with out error message.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Is it possible to update the target table with PK?
Why filter transformation is an active one?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
Could you explain what is enterprise data warehouse?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is size of u r database?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
What is the need of an ETL tool?
Why should we use star schema in datawarehouse design?
In any project how many mappings they will use(minimum)?
Teradata 
