Y.O.D.A.

Introduction

Y.O.D.A. (Yaro`s Oracle Data Admin) can manage objects in ORACLE database via HTML.
Web-based tool for developers and administrators of Oracle severs. Written in PHP to allow view,manage and export Oracle objects (tables, view, index, package, function, procedure, trigger..) over the WWW (similar function as phpMyAdmin and TOAD)

Currently Y.O.D.A. can:

login / logout to Oracle DB
browse, create and drop tables, views, indexes, packages, functions, procedures, triggers, type, materialized view, materialized view log, synonym, DB links, directory and sequences
create, copy, drop, search, rename and alter tables, fields and indexes
export data to various formats: SQL, LaTeX, HTML, ExcelCSV, CSV, XML
change user password
communicate in different languages
.. and others

A word about users:

Many people have difficulty understanding the concept of user management with regards to Y.O.D.A.. When a user logs in to Y.O.D.A., that username and password are passed directly to ORACLE. Y.O.D.A. does no account management on its own (other than allowing one to manipulate the ORACLE user account information); all users must be valid ORACLE users.

Requirements

PHP You need PHP 4.1.0 or newer, with OCI support
ORACLE 9.2 or newer

Installing Oracle, PHP, and Apache on Windows 2000/XP
Installing Oracle, PHP, and Apache on Linux

Web browser with cookies enabled.

Installation

Y.O.D.A. does not apply any special security methods to the ORACLE database server. It is still the system administrator's job to grant permissions on the ORACLE databases properly.

Untar or unzip the distribution (be sure to unzip the subdirectories) Y.O.D.A._x.x.x.zip in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and transfer the directory on your web server using, for example, ftp.
Ensure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem).
Now you can configure your installation. Traditionally, users have hand-edited a copy of ./php/config.php
Open the main Y.O.D.A. directory in your browser. Y.O.D.A. should now display a welcome screen

Credits

Y.O.D.A. - Credits
====================

CREDITS
-------------------------------

- Josef Jaroš aka YaroSH <yarosh_at_seznam.cz>
    * creator of the Y.O.D.A. project

- phpMyadmin lang file translators;
    * language file

Preview