Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> import question

import question

From: Cameron Abbott <cvabbott_at_altavista.com>
Date: Thu, 8 Nov 2001 16:10:22 -0500
Message-ID: <9ses8j$len$1@bcarh8ab.ca.nortel.com>


Hi All,

I have a database and have imported all the data into this new database from another database. I only exported the data of two users and mported it. This created all the tables,data,sequences and indexes. Has a test I want to drop the two users to remove all their objects, then recreate the users. My question is, if I do a full export and on the import set ignore=y, will the import over write the information in the new database for tablespaces and datafiles with the tablespace and datafile information in the old database? I do not want the database structure to change, I have made many modifications to the new database to increase its size because the old one was too small and I didn't have the disk space to make it larger.

If it do over write, what will happen when the directory structure of the old database does not exist on the new one?

Thanks

Cameron Received on Thu Nov 08 2001 - 15:10:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US