cancel
Showing results for 
Search instead for 
Did you mean: 

Can I create .............

SOLVED
Go to solution
Deanna Tran_1
Frequent Advisor

Can I create .............

Can I create 2 different tables on one tablespace? would this be valid? why and why not? thank you
3 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: Can I create .............

You can create N tables within a tablespace.

Deanna, this is such a fundamental question that it truly illustrates the need for some Oracle training on your part. This Forum is really not suited as a substitute for an Oracle class nor it is intended to be.

There is really no substitute for the purchase of a few Oracle tutorials, Oracle refernece books, and perhaps a few classes. The other requirement is spending a great deal of time trying things for yourself.


Regards, Clay
If it ain't broke, I can fix that.
Tim D Fulford
Honored Contributor

Re: Can I create .............

I'm not sure what you exactly mean. You can create multiple tables within a dbspace. In Oracle you can have tables whose rows contain tables, I've never done this so would not know how you can do it only that is what they say you can do...

Tim

-
Wodisch_1
Honored Contributor
Solution

Re: Can I create .............

Hello Deanna,

for your question: yes,

for your needs: go to http://technet.oracle.com and get a free account for the "Oracle Technology Network". Then go to the "documentation" pages and get all the official docs plus a lot of tips and tricks.
But the very first step would be to read the "DBA Handbook" by Kevin Loney:
http://shop.osborne.com/cgi-bin/osborne/scan/se=15452/fi=author2isbn/sf=authorcode/op=eq/sp=results%2ehtml/em=yes/st=db.html
and then the "Complete Reference":
http://shop.osborne.com/cgi-bin/osborne/0072225211.html

HTH,
Wodisch