My Name
eyck@kuszelas:com

Subscribe
Subscribe to a syndicated feed of my weblog, brought to you by the wonders of RSS.

• 2003 (34)
  • February (7)
  • March (11)
  • April (2)
  • June (1)
  • July (3)
  • October (2)
  • November (6)
  • December (2)
• 2004 (62)
  • January (3)
  • February (18)
  • March (16)
  • April (6)
  • May (4)
  • June (5)
  • July (2)
  • August (3)
  • September (2)
  • October (2)
  • November (1)
• 2005 (27)
  • January (10)
  • February (1)
  • March (5)
  • April (2)
  • May (2)
  • June (2)
  • August (1)
  • September (1)
  • November (1)
  • December (2)
• 2006 (10)
  • February (1)
  • March (2)
  • May (1)
  • August (2)
  • October (2)
  • November (1)
  • December (1)
• 2007 (14)
  • January (3)
  • February (1)
  • April (2)
  • May (1)
  • June (2)
  • August (2)
  • September (3)

Wed, 26 Nov 2003

Moving undo/temporary tablespace to another location

CREATE UNDO TABLESPACE undotbs02
DATAFILE '/opt/oracle/oradata1/sbrd/undotbs02.dbf' SIZE 3000M REUSE   
AUTOEXTEND ON;

ALTER SYSTEM SET UNDO_TABLESPACE = undotbs02;

DROP TABLESPACE undotbs01;

Theme Design by Bryan Bell.

• /(147)
• Benchmark(1)
• Howto(30)
• Lyrics(14)
• Eurotrip.OST(1)
• Love.Song.4.Bobby(1)
• Misc(14)
• Perl(4)
• Photos(1)
• Problems(2)
• Projects(18)
• Simpad(1)
• XTP(1)
• bsd(9)
• vserver(2)
• Quests(7)
• Rants(1)
• Talk(2)
• Tips(14)
• vmware-player(1)
• johnbokma.com(1)
• Todo(2)
• Training(1)
• Ugly notepad(4)
• WTF(2)
• Wycieczki(1)