Notes for using Oracle in appfuse

Http://www.blogbus.com/public/tb.php/1216089
The JRE of oracle9i is 1.3, which occupies the first item of the Environment Variable path after installation. The solution is to move this item to the last item of path.

If you use dbunit to add data to Oracle, if your user has DBA permissions and different users have tables of the same name, dbunit will not know which table to insert, you only need to reduce the user permission, and pay attention to the sequence of data inserted to tables with foreign keys.

My User roles are: connect and Resource
The system permission is: unlimited tablespace,
Create Table,
Create session,
Create tablespace,
Create sequence,
Create cluster,
Create trigger,
Create view ..

In fact, these system permissions can be customized according to your own needs. If you do not need the permissions to create an attempt, you certainly do not need to add them.