Philip Howe’s Oracle Blog

Just another WordPress.com weblog

Home
About

Recent Posts
Categories
- Application Server (4)
- ASM (1)
- Database (45)
  - 11g (2)
  - RAC (6)
- Enterprise Manager (2)
- General (1)
- Networking (1)
- Operating Systems (6)
  - Linux (1)
  - Unix (1)
  - Windows (3)
- RMAN (9)
- SQL (6)
- Uncategorized (2)
- Weblogic (2)
  - Node Manager (1)
  - Reports (1)
January 2010

M T W T F S S

« Oct Jun »

1 2 3

4 5 6 7 8 9 10

11 12 13 14 15 16 17

18 19 20 21 22 23 24

25 26 27 28 29 30 31
Archives
- December 2011 (1)
- March 2011 (3)
- December 2010 (1)
- October 2010 (1)
- September 2010 (1)
- August 2010 (1)
- June 2010 (1)
- January 2010 (2)
- October 2009 (1)
- July 2009 (1)
- June 2009 (4)
- April 2009 (23)
- March 2009 (27)
Blog Stats
- 10,777 hits
Pages
- About
Meta

Blogroll
- WordPress.com
- WordPress.org
My Other Blogs
Oracle Apex Blogs
- Dimitri Gielis
- Scott Spendolini
Oracle Blogs
- Oracle Alchemist
- Oracle Base
Oracle Links
Work
- My Oracle Blog
- My SQL Server Blog
Tags

allocate record buffer archive log archive log removed backup block blocks Chained Rows clone compare compare schema crosscheck database clone dba_data_files dba_free_space dba_jobs ERROR: Wrong password for user. exp forms 10g Host Credentials imp init ora lock locks log on as batch move index move table mtime number of rows OEM parfile profile RAC recovery RemoteOperationException remove files RMAN rollback rollback segments schema SCN size of index size of table Table Fragmentation v$lock v$session
Category Cloud

11g Application Server ASM Database Enterprise Manager General Linux Networking Node Manager Operating Systems RAC Reports RMAN SQL Uncategorized Unix Windows

Create Tablespace

Posted by philiphowe on January 20, 2010

create tablespace ts_name
datafile ‘c:\ts_name_01.dbf’ size 4M autoextend off,
‘c:\ts_name_02.dbf’ size 4M autoextend off,
‘c:\ts_name_03.dbf’ size 4M autoextend off
logging
extent management local;

Advertisement

Like this:

Be the first to like this post.

This entry was posted on January 20, 2010 at 2:32 pm and is filed under Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

« pfile of default 11.1.0.7 database

Move datafile script (unix or windows) »

Follow

Follow “Philip Howe's Oracle Blog”

Powered by WordPress.com