Posts Tagged ‘slave sql’

Slave Driving – Getting SQL*Plus to do it for you

January 9, 2010

In my haste to play around in my shiny new Oracle XE instance, I’ve forgotten to set the Default Tablespace for any new users I create.
As a result I’ve got few tables and indexes in the SYSTEM tablespace. Fortunately, I don’t have to go through the drudgery of moving all of them by hand, I can get SQL*Plus to do it for me. (more…)


Follow

Get every new post delivered to your Inbox.

Join 57 other followers