Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3288
  • Last Modified:

how to create tablespace in oracle 9i?

hi,

I am using eclipse as a IDE, and configured my db(oracle 9i) on it, but getting problem on creating tablespace?
0
kim_ray
Asked:
kim_ray
  • 2
1 Solution
 
sdstuberCommented:
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
 
MikeOM_DBACommented:

What problem?

Create the tablespace using SQL*Plus or iSQLPlus.
0
 
MikeOM_DBACommented:
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now