The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
623 views

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it ...
-1
votes
1answer
49 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
0
votes
0answers
40 views

How to backup the database before partitioning (RANGE) 100 GB database?

I want to carry out the partitioning activity. I am using oracle 11g R2. In case of error occurs while partitioning I might loose the data. On safer side I want to take backup of the database and if ...