• Twitter
  • Buzz
  • Facebook
  • LinkedIn
  • NetworkedBlogs
  • Digg
  • Picasa
  • Flickr
  • YouTube
  • Last.fm
  • Delicious
Komunitas Blogger Bekasi

Bekasi-IT – Blog Design

Bekasi-IT adalah adalah suatu lembaga yang bergerak dalam bidang IT Consultant dan Entrepreneurship dengan slogan Embrace Customer Satisfaction.

Subscribe to Feed

Tech Lounge

How To Create TableSpace in Oracle

Posted on: 5/17/2010 02:05:00 AM by Koharudin

Label: ,

     In this small post article i'll show you how to create tablespace in Oracle. You can  modify file location of tablespace or even modify it's size. Now just connect to Oracle Database via SQLPLUS as a previliged user.
Follow this simple instruction below :
  1. From your PC, click Start | Run
  2. In the Run dialog box, type
       SQLPLUS / sysdba
    and press ENTER
  3. Then follow the last attack. type the following script below :

    create bigfile tablespace [nameOfTablespace]
    datafile '[filenameOfTablespace]' size [sizeOfTableSpace] reuse autoextend on next 512M maxsize unlimited
    EXTENT MANAGEMENT LOCAL
    segment space management auto;


    for example :

    create bigfile tablespace sem_ts
    datafile 'sem_ts01.dat' size 512M reuse autoextend on next 512M maxsize unlimited    
    EXTENT MANAGEMENT LOCAL
    segment space management auto 



FYI : when you define sem_ts_01.dat without specifying parent folder, default location of the file is under
[ORACLE_HOME]\database.

How to check oracle_home in my computer? see this tips

Thanks


Artikel Menarik Lainnya

Tidak ada komentar:

Poskan Komentar

What we can do!

  • Web & Interface Design You have a vision - and we have the ability to convert that vision into a living breathing website.
  • Develop Application Do you wish to have an application either running on desktop, web , or even your mobile device. We already help you to bridge your dream
  • Blog Design Our free blog themes have been downloaded over 100,000 times. We can transform your blog from generic and drab into eye-popping and converstation-starting.
  • Markup and Style Optimization HTML, CSS, and JavaScript optimization. Transform your website from sluggish to lightning fast.

Recent Comments

Latest Blog Entries

Historical Readers

Web Hosting

We get asked a lot - who should we use for web hosting? We recommend HostGator Web Hosting

#