First, yes, you can run Oracle 9i on XP Pro. And secondly, since you're running XP Pro, you'll have to load a 9i database as Oracle has not certified Oracle 8i to run on XP Pro (and doesn't plan to). Only the 8i client has been certified to work, not the database. So, with your hardware, you'll have to go with learning on a 9i database.You can download a free trial copy from or order a trial CD Pack for around $40 or so. You then can choose which version of the database you install to learn from (Personal, Standard, Enterprise). I'll assume that you know SQL, etc., since you've been in the DBA biz on the mainframe side, so if you really want to learn Oracle you'll probably want to look at the Enterprise edition. Installing this should give you a full-featured look at Oracle.Learning Oracle is challenging when it's brand new, but there are lots of resources, both from Oracle and from many third party sites and forums.
There are also lots of CBTs available that you might find helpful. Pick up a few books, browse around this site and others for good Oracle info and links and have at it!For More Information. Dozens more are available.: tips, tutorials, scripts, and more. Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize.!.
Ask your technical Oracle and SQL questions - or help out your peers by answering them - in our. yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
More on Oracle 8iData Added 1: May 17, 2009SoftDream Oracle UnWrapper is a unwrapping software for Oracle 7/8i/9i/10g/11 with unwrapping package,package body, stored procedures, triggers, views,type,etc,If you wrapped your own source code(pl/sql script) of package, procedures, triggers, views or user-defined functions with Oracle Wrap Util,but you neglectful lost it,the application can help you unwrapping and recovery it. Now feel the convenience of SoftDream Oracle UnWrapper! All versions of Oracle are supported.Work in Oracle.Size: 4.5 MB License: Shareware Price: $98 Keywords: -Data Added 1: June 21, 2007Repgen generates the scripts required to setup and monitor an Oracle 8i/9i database Advanced Replication installation. The implementation of primary key, replication triggers and multiple conflict resolution methods is included. Licensed customers of Repgen Enterprise Edition receive source code and the ability to make site-specific customization of the generated files via an external module. Free demo available for Windows, Solaris, Linux and MacOSX.
You don't have to be the world's.Size: 1.1 MB License: Shareware Price: $5000 Keywords: -Data Added 1: February 25, 2010It uses PHP4 to offer simple Oracle object browsing, multiple database connections and easy viewing of Oracle 8i database structures. Phporacleadmin.orgSize: 54.0 KB License: Freeware Keywords: -Data Added 1: September 20, 2012Oracle DBA's module for Oracle 8i, 8.0 and 7.3.
Reverse engineers DDL for specified list of objects. Defrags entire tablespaces.
Resizes tables/indexes to your standards. Creates user X with privileges of Y. Etc., etc., etc.Size: 54.8 KB License: FreewareData Added 1: June 03, 2013LightSQL is an excellent tool for oracle development environment, specially designed for oracle 8i, 9i and 10g databases. You can download or export the results as text file, excel sheet, xml document or as insert statement.
Public DomainSize: 7.6 MB License: FreewareData Added 1: August 03, 2012Recovery for Oracle is a comprehensive tool designed to recover data from damaged Oracle databases and backups. Special wizard-style interface gives users more control over the recovery process.
Recovery for Oracle restores database tables, fields, fields types and values, as well as all backup objects, including views, triggers, stored procedures etc. New integrated data recovery center implementation - all standalone OfficeRecovery products now united with common convenient for end-user.Size: 1.1 MB License: Shareware Price: $399 Keywords: -Data Added 1: December 10, 2012Dbmover for Oracle to Mysql is a powerful tool to import Oracle contents into MySQL database. DBMover allows you to define flexible table/field mappings between MySQL and Oracle databases. It also lets you perform a query and use the query result as a data source during migration.
Dbmover for Oracle to Mysql allows to automate and schedule the conversion process. Features of Dbmover for Oracle to Mysql: - Support for Oracle 8i and any later version. Support for MySQL 3.23.x and.Size: 5.6 MB License: Shareware Price: $19 Keywords: -Data Added 1: June 21, 2007The Installgen application implements Oracle´s best practices for over 100 tasks required when performing the installation of Oracle primary and standby database servers. This graphical application generates dozens of scripts, configuration files and documentation within a few seconds. An external module allows site-specific customization of each generated file. Features: - Platform Specific Functionality for Solaris, Windows, Linux and Mac OS X - Improved Security Implementation -.Size: 2.2 MB License: Shareware Price: $1299 Keywords: -Data Added 1: June 21, 2007Lattice.SPGen is a template-based stored procedure and code generator that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, PostgreSQL and MySQL. It processes any tables and views in the database that you select and generate stored procedures scripts of insert, update, delete, select (single or multiple records) as well as business entities for C# and VB.NET. The output scripts file can be chosen as one file for all tables / views or one per table / view based on your.Size: 235.4 KB License: Shareware Price: $88 Keywords: -Data Added 1: June 16, 2013SQLTools is a light weight and robust frontend for Oracle database development.
This program is not so comprehensive as Tora or TOAD but it is ideal when you need basic data querying capabilities and objects browsing. It also supports a basic subset of SQL.Plus commands (connect/disconnect, bind and define variables).It works with Oracle 8i/9i/10g/11g databases. Oracle Client 32bit is required. Check for more.Size: 1.2 MB License: FreewareData Added 1: September 30, 2013OCILIB is an open source library, written in C, that access Oracle Databases.
OCILIB project encapsulates OCI ( Oracle Call Interface - a low-level programming interface provided by Oracle) which is a powerfull but complex API. OCILIB is built on top of OCI, hiding its complexity and proposes instead a more simple, readable and reusable API.
OCILIB is free (open source - LGPL) and its source code is platform independant. It offers up to 150 simple.Size: 1.3 MB License: Freeware Keywords: -Data Added 1: December 12, 2007DataRoamer is a tool for easily exploring the structure and data in a relational database. DataRoamer's GUI interface provides point and click schema navigation and queries.
Features include: Tree-like navigation of the database schema. Point and click data selection.
Multi-column sorts. Right-click menus and tooltips make it unnecessary to remember commands. Autocomplete dropdowns for text entry, created from the database. Multiple windows can be open on one or.Size: 520.0 KB License: Shareware Price: $55 Keywords: -Data Added 1: May 11, 2009Document your database structure and generate customized reports as xml, html, Microsoft Word or PDF documents. View all database objects like tables, queries, keys, relationships, stored procedures and triggers.
Preview the database structure report and save individual pages. Report all or selective database objects. Alternatively you can apply your own css to the reports. Migrate all or selected database objects between supported databases. View, insert, update, delete data and execute.Size: 11.1 MB License: Shareware Price: $89.99 Keywords: -Data Added 1: June 22, 2008TierDeveloper 5.6 is the industry standard for Object to Relational mapping and code generation tool that helps you rapidly design, generate and deploy middle-tier-objects for your enterprise applications. It is designed to enable developers to build BUSINESS FRAMEWORKS with an instant increase in productivity and at the same time greatly simplifying the management of change.NET Framework 2.0 Support - Visual Studio.NET 2005 Integration - New Mapping Wizard provided to do N-N.Size: 21.7 MB License: Shareware Price: $1495 Keywords: -Data Added 1: October 07, 2008Document your database structure and generate customized reports as xml, html or Microsoft Word documents. View all database objects like tables, queries, keys, relationships, stored procedures and triggers.
Preview the database structure report and save individual pages.Report all or selective database objects. Alternatively you can apply your own css to the reports. Migrate all or selected database objects between supported databases.
View, insert, update, delete data and execute stored.Size: 7.0 MB License: Shareware Price: $199Data Added 1: May 05, 2012AuditPro - Enterprise Edition is a comprehensive enterprise security assessment solution featuring critical asset identification, policy compliance, risk analysis, real time vulnerability views, enhanced reporting capability, graphical progress analysis and more. Supporting multiple operating systems and databases, AuditPro brings you the state-of-the-art in information systems security evaluation and risk management. It comes with in-built policies for compliance with PCI DSS, ISO 27001.Size: 10.5 MB License: Freeware Price: $1000 Keywords: -Data Added 1: June 08, 2014Repairs corrupted Oracle databases. Supported Oracle versions:7.3,7.3.3, 8i,9i,10g,11g. The recovered data is saved into a set of SQL files to be used for rebuilding Oracle database.
This can be done manually or using an auto-generated rebuild batch file. Data Browser added - Data Browser is a new feature bundled with the product, available from the same program group where Recovery for Oracle is installed.
It is a separate granular data recovery utility to view and extract individual items.Size: 4.6 MB License: Shareware Price: $599 Keywords: -Data Added 1: June 21, 2007Hxtt Data Export - Access2Oracle is a program to import MS Access(95, 97, 2000, XP, 2002, 2003) into Oracle(8, 8i, 9, 9i, 10g) database. The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It includes a wizard, which allows you to set convert options for each table visually (destination filename, exported fields, column types, data.Size: 2.4 MB License: Shareware Price: $48.85 Keywords: -Data Added 1: June 21, 2007Hxtt Data Export - DBF2Oracle is a program to import DBF(dBASE(II, III, IV, V, 2000), FoxBase, FoxPro, Visual FoxPro(3.0, 5.0, 7.0, 8.0, 9.0, 10)) into Oracle(8, 8i, 9, 9i, 10g) database. The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It includes a wizard, which allows you to set convert options for each table visually.Size: 2.2 MB License: Shareware Price: $48.85 Keywords: -Data Added 1: June 21, 2007Hxtt Data Export - Oracle2Paradox is a program to import Oracle(8, 8i, 9, 9i, 10g) database into Corel Paradox(3.0, 3.5, 4.x, 5.x, 7.x, 8.x, 9.x, 10,x, 11.x).
The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It includes a wizard, which allows you to set convert options for each table visually (destination filename, exported fields.Size: 2.1 MB License: Shareware Price: $48.85 Keywords: -Data Added 1: June 21, 2007Hxtt Data Export - Oracle2Text is a program to import Oracle(8, 8i, 9, 9i, 10g) database into TXT(CSV, TSV, PSV). The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It includes a wizard, which allows you to set convert options for each table visually (destination filename, exported fields, column types, data formats, and many others).Size: 2.1 MB License: Shareware Price: $31.85 Keywords: -Data Added 1: June 21, 2007This application will allow you to transfer tables to and from Microsoft Access and Oracle databases. Importing and exporting can be done without SQL knowledge. This program saves time if you need to transfer tables between the two databases quickly.Size: 403.7 KB License: Shareware Price: $29.82 Keywords: -Data Added 1: June 21, 2007This application will allow you to transfer tables to and from MS SQL Server and Oracle databases.
Importing and exporting can be done without SQL knowledge.Size: 404.5 KB License: Shareware Price: $29.82 Keywords: -Data Added 1: June 21, 2007This application will allow you to transfer tables to and from Oracle and FoxPro databases. Importing and exporting can be done without SQL knowledge. This program saves time if you need to transfer tables between the two databases quickly. Connect via DBC file or multiple DBF files in a folder.Size: 403.2 KB License: Shareware Price: $29.82 Keywords: -Data Added 1: June 21, 2007This application will allow you to transfer tables to and from Oracle and PostgreSQL databases. Importing and exporting can be done without SQL knowledge.
This program saves time if you need to transfer tables between the two databases quickly.Size: 406.6 KB License: Shareware Price: $29.82 Keywords: -Data Added 1: June 21, 2007Quickly transfer tables to and from Oracle and Sybase ASA (Adaptive Server Anywhere) databases. Importing and exporting can be done without SQL knowledge. This program is not intended for use with Sybase Enterprise.Size: 405.0 KB License: Shareware Price: $29.82 Keywords: -Data Added 1: June 21, 2007OracleRecovery is a comprehensive tool designed to recover data from damaged Oracle databases and backups.
Special wizard-style interface gives users more control over the recovery process. OracleRecovery restores database tables, fields, fields types and values, as well as all backup objects, including views, triggers, stored procedures etc. New integrated data recovery center implementation - all standalone OfficeRecovery products now united with common convenient for end-user GUI.Size: 1.1 MB License: Shareware Price: $399 Keywords: -Data Added 1: June 21, 2007Hxtt Data Export - Excel2Oracle is a program to import MS Excel spreadsheet(95, 97, 98, 2000, 2001, 2002, 2003, 2004) into Oracle(8, 8i, 9, 9i, 10g) database. The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It includes a wizard, which allows you to set convert options for each table visually (destination filename, exported fields.Size: 2.1 MB License: Shareware Price: $48.85 Keywords: -Data Added 1: June 21, 2007Hxtt Data Export - Oracle2Access is a program to import Oracle(8, 8i, 9, 9i, 10g) database into MS Access(95, 97, 2000, XP, 2002, 2003). The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX.