Solved

how to create tablespace in oracle 9i?

Posted on 2008-10-20
5
3,269 Views
Last Modified: 2013-12-19
hi,

I am using eclipse as a IDE, and configured my db(oracle 9i) on it, but getting problem on creating tablespace?
0
Comment
Question by:kim_ray
  • 2
5 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
Comment Utility
what command are you using?  It should look something like this...
Some of these options aren't required, and of course, adjust the sizes to whatever you want

CREATE TABLESPACE your_tablespace DATAFILE
  '/put/your/path/here/your_file.dbf' SIZE 10M AUTOEXTEND ON NEXT 64M MAXSIZE 2G
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility

What problem?

Create the tablespace using SQL*Plus or iSQLPlus.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now