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
