Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIFOD Schema dump

Received Response
11
Views
1
Comments
Sree!!!
Sree!!! Rank 3 - Community Apprentice
edited Aug 13, 2024 6:58PM in Oracle Analytics Cloud and Server

Hi Experts,

Where I will get the BIFOD schema dump( tables and data). I have downloaded the RPD from oracle site. They have provided the BISAMPLE dump but I didn't find any dump related to BIFOD. Can you please help me out where I will get this.

pastedImage_0.png

Regards,

Sree!!

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    First, to clarify I have never used the bi sample.

    The question is: do you have an Oracle Virtual Box Machine with this sample?

    if the answer is yes then do these steps:

    0. open the connection properties in your RPD,check what is your schema (database user), go to the OS a apply these commands:

    1.

    CONN / AS SYSDBA

    ALTER USER scoot IDENTIFIED BY tiger ACCOUNT UNLOCK;

    2.

    CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';

    GRANT READ, WRITE ON DIRECTORY test_dir TO scott;

    3.

    expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log

    Kind Regards,