Re: Minimal database files set.

        Hi Ilya,

        I have a stupid question. Why do you need to create a new database? Why can't you just create a new user and copy the tables to the new users schema?

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/30/00, 6:30:57 PM, "Ilya Kuzkin" <ikuzkin_at_fbc.ca> wrote regarding 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 Thu Jun 01 2000 - 00:00:00 CDT