automatic database refresh in oracle

[Former Member]

Hi all,

any help on this would be appreciated.

we are doing a daily refresh in Solaris database in which we

1. bcp  out of tables sysusers, sysprotects and sysalternates

2. Refresh the database

3.bcp in OF   above  sys tables

so, for an automatic database refresh in oracle, can anyone anyone suggest what system tables can be used in oracle.I found sys.all_users and sys.all_tab_privs can do, but it should not affect  otherschemas and  we add  dailyonthe and database and that should not cause any problem.

can anyonesuggest on this???

[Former Member]

What is a Solaris database? I always thought of a Solaris as operating system...

We don't use export/import on Oracle with SAP schemas (too big).

You can:

- create a snapshot on storage layer (disk mirroring)

- do a backup / restore

- use Oracle Flashback     <--- would be my preferred method

As always you would have to have a procedure to apply changes to the system, like SAP patches, new application data and things.

Cheers Michael

PS: Sybase often runs on Solaris though, and has the sysprotects and friends 😉