Minimal database files set.

Hello All,

My DBA career counts only 2 weeks (after 4 years as developer), so sorry if question is stupid.

The problem is: I have Cold Backup of database (Oracle 8.0.5) and I need to create database consisting only 4 tables from one schema (all tables are in the same datafile). I cannot use dump files, because I dont have any for that point of time. I have only 3 gigs of free drive space and all database files take about 40 gigs.
The conditions are: all database files are well separated and datafile containing those tables is not big (about 1.5 gigs) The question is: what is minimal set of database files to organize database, containing those tables. What files must be included and what files are optional?..

Sincerely, ilya Kuzkin. Received on Tue May 30 2000 - 00:00:00 CDT