Home -> Usenet -> comp.databases.oracle -> HELP WITH IMPORT/EXPORT

HELP WITH IMPORT/EXPORT

From: David Roze <droze_at_jarrah.com.au>
Date: 1995/09/05
Message-ID: <42ge20$1ds_at_sydney1.world.net>#1/1 






Hello everyone,



I'm relatively new to Oracle and would like a bit of assistance 
with IMPORT/EXPORT.



We have a situation here where we have two tablespaces defined 
in a database - one being for development and the second for 
testing. I have been assigned to the latter. Both tablespaces 
will contain identical table definitions, integrity 
constraints, etc. and both sets of tables are likely to be 
created by our DBA.



As I understand it, in order to export Sequence information you 
need to perform an export in User mode. That means I need the 
EXP_FULL_DATABASE privilege to export objects created by the 
DBA. The thing is I only need to export the objects from the 
test tablespace. My suspicion is that if I do an export in user 
mode specifying the DBA's schema this will result in objects 
from both tablespaces being exported. Is this correct? If so 
does anyone know of a way I can export the objects contained in 
my own tablespace only?



The most obvious way around it is if I create the tables myself 
but i am unsure as to whether or not this is acceptable for our 
purposes.



The reason I need to know all this is because I have been 
assigned the task of tester for this SQLWindows app we are 
developing against Oracle. I envisage using export/import as 
the means of bringing the test database back to its original 
state after performing tests.



Thanks,


David Roze
Received on Tue Sep 05 1995 - 00:00:00 CEST












Original text of this message