Bisample schema

This would be helpful for begineer. Those want to do practices on bisample schema.

First of all download bisample schema. Click Here to Download BISAMPLE schema

After downloading extract the Zip file and follow below step

1. Create the BISAMPLE user/schema. 

Open a connection to the database with system or DBA privileges.

Run the script BISAMPLE_USER.SQL to create the BISAMPLE user/schema.

Once executed, verify that you can successfully connect to the database as user BISAMPLE with password BISAMPLE.

IMPORTANT Note: The BISAMPLE user creation script creates the password BISAMPLE (same as user name). To simplify completion of this tutorial, it is recommended that you do not change this user password.

===============================================================================

2. Load BISAMPLE tables and data

Open a connection to the oracle db with BISAMPLE/BISAMPLE user. 

To create the BISAMPLE tables, run BISAMPLE_SCHEMA_825.SQL.

To populate the tables with data, unzip BISAMPLE_DATA_825.zip and run BISAMPLE_DATA_825.SQL.

==============================================================================

3. Verify

Once the BISAMPLE schema is loaded, verify that the tables have been created and populated by issuing commands in SQL*Plus. For example, SELECT COUNT(*) FROM SAMP_REVENUE_F should return 20000 rows.

Thanks 

Rakesh Patl