Latest Fun

This is great for getting a list of installed features from a windows server. So far I’ve only tried do this locally aside from a quick test on a Windows 7 machine, from which it failed.

In powershell:
IMPORT-Module servermanager
Get-WindowsFeature

Source: http://blogs.msdn.com/b/powershell/archive/2009/01/27/managing-server-features-with-powershell-cmdlets-on-windows-2008-server-r2-beta.aspx

This is easy!

First tell the system where you want the table space:
ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/home/oracle/app/oracle/oradata/orcl';

Next, name and create the tablespace:
CREATE TABLESPACE [YourTableSpace];