Sounds like you might want to check out Oracle's Workspace manager as a
possible option.

If you do, learn about it using the Oracle9i R2 documentation & database,
if possible. Then, if necesary, backport your experience to an older
version of the database as it's been available since 8.1.6 but poorly
documented and poorly understood 'till recently. The 9iR2 OEM has decent
graphical suport for this as well & the OBE section of OTN has a good set
of demo samples.