Re: Is anybody using Personal ORACLE..?

Jason Pociask (pociask_at_names.maricopa.edu) wrote:
: Does Personal Oracle - the trial version - include Forms 4.0, Reports 2.0,
: and that kind of stuff? Can Forms or other PL/SQL code you write using
: Personal Oracle be easily moved to regular Oracle on a Unix platform?
 

: Copy me on email please if you have that options - thanks.
 

: Jason Pociask pociask_at_names.maricopa.edu

..........................................................

Question: What does Personal Oracle include? Answer : Personal Oracle includes Oracle 7.1 rdbms and Database Manager, Database Expander, Object Manager, Session Manager. User Manager, Import, Export, SQL*Loader, Database Tools User's Guide, Oracle7 Documentation, Password Manager, Backup Manager, Recovery Manager, SQL*DBA, Oracle Objects for OLE, Oracle Installer, SQL*Plus 3.1, and ODNC Administrator. I left a few things out like user's guides. Personal Oracle does not include SQL*Forms or SQL*Reportwriter.

I was able to import an Oracle user including about forty tables and twenty views from rdbms version 6.036 under SCO Unix. The import program was unable to recreate a view with six outer joins, I haven't investigated that yet. I haven't seen anything equivalent to termdef (for defining function key) or printdef (for defining custom printer drivers).

Question
: Can Forms or other PL/SQL code you write using Personal Oracle be
: easily moved to regular Oracle on a Unix platform?
Answer: To move a form generated in SQL*Forms to any platform you need to move the inp file and generate it on the new platform. A form can be moved to or from any platform that Oracle supports. I have noticed that moving forms between unix/dos (or OS2), and dos/unix triggers and Sql*plus commands that use host commands need to be modified to the correct syntax for each operating system. All PL/SQL or SQL*Plus code, is just ASCII text. I have seen small problems with porting between different os's when the os's had different version's of Oracle software.

Noah Monsey
noah_at_indirect.com Received on Mon Jan 23 1995 - 13:22:05 CET