SQL Important Interview Questions

What is the difference between truncate and delete ?

Snowflake Interview Questions

What is Time travel 

What is Fail safe?

How to use DB functions in OBIEE

What is Evaluate function in OBIEE ?

It is used for calling database functions from answers ( front end) or  from rpd ( by using in logical column )

Syntax

Evaluate('db_function(%1...%n)' [as datatype] [, column1, columnn])

Example

Evaluate('to_date(%1,%2)' as char ,'20130326','yyyymmdd')

Like this any db function can be used with OBIEE

how to reset OBIEE 10G Administrator Password

Hi,

Follow the link by satya. Really nice and simple steps.

http://satyaobieesolutions.blogspot.in/2013/06/how-to-reset-forgotten-obiee-10g-rpd.html

How to import oracle dump file .dmp ?

How to use import database in oracle using imp utility ?

1.       Create the target user first

SQL> create user supplier2 identified by trpass123 default tablespace users quot

a unlimited on users;

User created.

2.       Provide necessary privillages to user

SQL> grant connect, create session, imp_full_database to supplier2;

Grant succeeded.

3.       Finally importing dump file

C:\Documents and Settings\Admin>imp supplier2/trpass123@orcl file=D:\SUPPLIER2\SUPPLIER2.dmp  full=Y

Here is what it looks like. Don’t use any ‘ or other special characters for file name

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Admin>sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Feb 13 09:42:07 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user supplier2 identified by trpass123 default tablespace users quot

a unlimited on users;

User created.

SQL> grant connect, create session, imp_full_database to supplier2;

Grant succeeded.

SQL>

 Now run the below utility in command prompt.

C:\Documents and Settings\Admin>imp supplier2/trpass123@orcl file=D:\SUPPLIER2\S

UPPLIER2.dmp  full=Y

 

Repository Creation Utility RCU

How to install oracle RCU 

How to download oracle RCU ?

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html

At the bottom of page look for the image below

 

Click on RCU according to your os and architecture.

Oracle documentation 

http://docs.oracle.com/cd/E14571_01/doc.1111/e14259/toc.htm