Assuming that my primary backup strategy is
nightly file backup ( oracle 9i on small Database < 500M )
I am wondering wheter a nightly User( owner ) Export might be more than
sufficient for a secondary backup of table info assuming we have all
the updated scripts to recreate the database, tablespaces, users,
tables, synonyms, constraints,roles and grants? If all I really care
about is the data. I am just wondering whether doing a FULL Export is
overkill vs User Export. Or is the basic rule of thumb of having more
information better? Is there more complexity to using the Import
utility from a FULL vs. Table or User?
Thanks
Rob
Received on Mon Dec 20 2004 - 15:47:06 CST
