Steps to import BISAMPLE Schema for OBIEE12c training.

1: Navigate to the lactation 

C:\app\OracleHomeUser1\product\12.1.0\dbhome_1\NETWORK\ADMIN

Open tnsnames.ora file and add the below tns entry and save the file

PDBORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = pdborcl)

    )

  )

2: Open your SQL Developer and run the below query as SYS user

ALTER PLUGGABLE DATABASE ALL OPEN;

3: Creating BISAMPLE user and gave privileges.

Connect as pdborcl and run the query attached (BISAMPLE_USER.SQL)  

For creating user and giving privileges

4: Unzip the dump files (Link) that you downloaded into the below location

C:\app\OracleHomeUser1\oradata\ForOBE

5: Query to create a directory that pointing to the dump files

Run the query from pdborcl

CREATE OR REPLACE DIRECTORY datapumpdir as 'C:\app\OracleHomeUser1\oradata\ForOBE';

To verify the directory is created use the below command

SELECT * from ALL_DIRECTORIES.

6: Command to import the schema.

Open command prompt and run the command.

impdp system/<Password>@pdborcl directory=datapumpdir dumpfile=BISAMPLE.dmp logfile=BISAMPLE.log

Now all the tables will be imported to the schema BISAMPLE.