Home
How It Works
Daily Challenge
Contact

Companies
Register
Login
Recruiter Tools
Post SqlAds
Resume Razor
Candidates
Register
Login
My Info
Employment
Submit Question
Training
Intro to
Informatica
Ask Mark
Recent Topics
Resume Courier
Top 10
grabowski
vlg
anjugarg
billw
jjahns
drj
nisha
nishardhini
grifman
kalaabhyas
 
© 2006 Saiko Consulting
All Rights Reserved.
50 Fox Hill Drive
Clinton, CT 06413
860-664-1936

Pete Russitano Design >


Yesterdays Results
 86% Correct
14% Incorrect
Sponsored Jobs
Data Analyst
Shelton, CT
MSAccess, SQL Sever, SQL, DBase, Clipper, Foxpro   more...
Contact Us
Production Support Analyst - Unix, FTP
Bristol, CT
Momentum, Odin, ConnectDirect, Tidal, BARR, and Tandem application and O/S software   more...
Contact Us
Project Manager (Multiple)
Windsor, CT
Junior to Senior Level Project Managers with Insurance Background   more...
Contact Us
IT Analyst (business analyst)
Bristol, CT
documentation, user interaction re: full sdlc responsibility. Security access, full sdlc, post-requirement.   more...
Contact Us
Data Modeler
Shelton, CT
UML, Rational, RequisitePro   more...
Contact Us
DB2 DBA
New Haven Area, CT
DB2, DBA, Logical & Physical Modeling   more...
Contact Us
DataStage Developer
Iowa, IA
DataStage, Informatica, Oracle, Team Leader   more...
Contact Us
Saiko Consulting's SqlChallenge
Saiko Consulting's SqlChallenge
CareerFactor
Saiko Consulting

Read A Topic

Return To Topics Originally Posted:  6/6/2006 2:33:59 PM
  Last Updated:  6/6/2006 2:33:59 PM

Subject:
What is the DEFAULT TABLESPACE for a CREATE TABLE statement

You Asked....
This is a problem I faced in a production environment but rather than the table being created in the USER tablespace it was created in the SYSTEM tablespace.

Why is that?

and we responded....
When creating a user in Oracle the DEFAULT TABLESPACE needs to be specified as a parameter if not supplied Oracle will default to the SYSTEM tablespace.

others said.... Post Your Own Review