SOA - Fusion Middleware

Primarly Consists of Note on: -Unix Sys Admin Tasks -Oracle Fusion Middleware Tasks -Oracle DBA Tasks

Monday, February 1, 2010

How to Extend a Table Space

If you run out of Table Space on any of your database
you can extend with the following SQL:

ALTER DATABASE DATAFILE '+SOAUAT_DATA01/idmuat/datafile/idmdata_ts.433.676232907'
AUTOEXTEND ON
NEXT 1000M
MAXSIZE 17000M;
commit;
Posted by Unknown at 10:16 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2014 (1)
    • ►  January (1)
  • ►  2013 (1)
    • ►  February (1)
  • ►  2011 (2)
    • ►  October (1)
    • ►  June (1)
  • ▼  2010 (7)
    • ▼  February (6)
      • How to add a user to to Administrator in Webcneter
      • How to Configure RSS feeds for Webcenter
      • Weblogic Server Shutting down automatically - BEA-...
      • Oracle B2B setup over AS2
      • How to Setup Oracle Webcenter Spaces
      • How to Extend a Table Space
    • ►  January (1)
  • ►  2009 (1)
    • ►  July (1)
  • ►  2007 (1)
    • ►  July (1)

Labels

  • AutoDeploy (1)
  • truncate Queue Table (1)
Simple theme. Theme images by rajareddychadive. Powered by Blogger.