tablespaces – Learning is not a spectator sport

Can you solve this blocksize puzzle?

Here’s a little puzzle to get your mind working It is generally well known that there is a limit to

Space management used to be hard Way back in the good old days…In fact, before I continue, rest assured that

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by

(Cueing my deep baritone Morpheus voice…) What if I told you that you can reference non-existent tablespaces in your DDL?

If you’re appropriately licensed and want to use advanced index compression, you can take advantage of the setting a tablespace

I was reading an interesting discussion today about multiple databases each containing large amounts of read-only data. If that read-only

I was trying to transport a large number of tablespace datafiles from one database to another, and impdp kept crashing

grrr… SQL> drop tablespace MY_TSPACE including contents; drop tablespace MY_TSPACE including contents * ERROR at line 1: ORA-00604: error occurred

You pick up little funny things in the day to day with Oracle. Like this one when you try to