New answers tagged tablespaces
2
I have not done it but, if not mistaken, it can be easily accomplished with tablespaces.
Let us know how it went.
0
ALTER USER <user> QUOTA 100M ON <user>;
GRANT UNLIMITED TABLESPACE TO <user>
5
You've missed one place to get an overview of Oracle: the Concepts Guide. It covers all the major topics (including backup and recovery, which is quite important and doesn't appear in the list of links you've posted).
Whats the next step? Create the Schema or Tablespace?
Both! They're orthogonal. Users are logical entities that access your database. ...
1
TL;DR to be able to restore data+undo without overwriting the entire current undo.
When you perform RMAN online backup, some transactions are in the middle of processing, they did change something but not yet performed their COMMIT. Transactional model of work ("atomicity") requires those transactions to be rolled back (completely undone) on recovery. ...
Top 50 recent answers are included
