TEC 5323 Advanced Database Technology
Oracle 12c Problems with Downloaded Class Scripts
(Updated May, 2019)
As a result of running "chap04.sql" script downloaded from our course web site, it is supposed to create a database user named as "PRACTICE04" and several tables. If you installed Oracle 12c in your computer, you may encounter the following error code: Becasue of the above error, it will not allow you to create a database user such as "PRACTICE04" in your database. Consequently, you will not be able to do the exercises as described in our class notes. There are a few work-arounds for this problem. I recommend the following approach for our students in this class.
You should be able to use "chap04.sql" and follow all the exercises as described in our class notes. Of course, if you do some research, you will be able to find other solutions to this problem. I encourage you to do your research and I sincerely welcome any other solutions. They are all acceptable as long as they work for you.
|
School of Technology
College of Business & Applied Sciences
Eastern Illinois University