This is a smaller version of the full Internet Movie Database.

-----------------------------
This database is too large to (responsibly) commit to GitHub or Bitbucket.
	They allow <1G repos with <100M files, which could hold this database if I
	split the data_actors.sql into two, but they also say that large SQL command
	files don't work that well.

The command files roughly match those of the the CS 342 sample databases in GitHub.
See the cs342/kvlinden/src/databases GitHub repo for details.

-----------------------------
To load the imdbLarge, load the *.dmp file using Oracle Datapump. The command files
must be loaded in C:\projects\cs342\cs342-resources\databases\imdbLarge\. To load
the database, use the create.sql script to create a new imdbLarge user and then use
datapump to load the dump files, as follows.

	DOS> cd C:\projects\cs342\cs342-resources\databases\imdbLarge\
	DOS> sqlplus system/bjarne
	SQL> @create
	SQL> exit
	DOS> impdp imdbLarge/bjarne parfile=imdbLarge.par

-----------------------------
To build the dump files in first place (not required for the imdbLarge), use expdp.

	DOS> expdp imdbLarge/bjarne parfile=imdbLarge.par

Be sure that:
 - Your database is loaded under its own user account. These sample files are configured to load the
    database, not to dump it, so you should modify the create file to @load the data.
 - You've created the emp_dir; use these command, with the appropriate directory (see create.sql for details).
        DROP DIRECTORY exp_dir;
        CREATE DIRECTORY exp_dir AS 'C:\projects\cs342\cs342-resources\web\resources\databases\imdbLarge';
        GRANT READ, WRITE ON DIRECTORY exp_dir to imdbLarge;
 - Run your commands in the exp_dir specified above.
 - The *.par file specifies the relevant elements of the database dump, including the qualified table names.

For details on Oracle Data Pump, see https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm.