- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Question in regards to table vs tablespace
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-31-2002 11:07 AM
тАО05-31-2002 11:07 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-31-2002 11:29 AM
тАО05-31-2002 11:29 AM
SolutionIf you are logged in as the same user who owns the table - you can then just do a "desc table_name" to see it. If the table is owned by a user other than the one you are currently logged in as - then that user will need "select" permissions in order to see the table (and will also need to preface it with owner.table_name or have a synonym created).
Jeanine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-31-2002 09:59 PM
тАО05-31-2002 09:59 PM
Re: Question in regards to table vs tablespace
Deanna, the tablespaces are the physical files, where you store the data.
The tables are logical items, which have to be created in the tablespaces.
If you check the syntax for the create table, you will see, that there is a step for the tablespace in it.
Try to get some training manuals for dba. You might find some valuable stuff in there. O'Reilly has got some good books on that.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-01-2002 11:03 PM
тАО06-01-2002 11:03 PM
Re: Question in regards to table vs tablespace
In your unix whenever the user creates a file,it is stored in the home directory of the user or he can create the file where he has permissions.Just like that whenever you create a table the table is created in the users default tablespace.
As like when you are creating user in unix you give him a default directory,when creating user in a oracle you allocate him to use a default tablespace.so when he creates a table it gets stored there.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-03-2002 11:52 PM
тАО06-03-2002 11:52 PM
Re: Question in regards to table vs tablespace
CREATE USER test IDENTIFIED BY test
DEFAULT TABLESPACE DATA1
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT;
Then create a table .
CREATE TABLE TEST1
(
col1 VARCHAR2(20),
col2 VARCHAR2(20),
)
TABLESPACE DATA2;
if not put the tablespace cause the table will goto default tablespace that say when create user.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2002 06:56 AM
тАО06-04-2002 06:56 AM
Re: Question in regards to table vs tablespace
and thank you for your time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2002 10:42 PM
тАО06-04-2002 10:42 PM
Re: Question in regards to table vs tablespace
I would recommend you to create your tablespaces properly first.
YOU MUST use Locally Managed Tablespaces.
The performance gain is in the allocation of new extents. I love LMT's not only
cause they are faster at allocating extents but because they make fragmentation
a thing of the past -- it just doesn't happen.
This is the future of tablespaces. Especially in 9i when we do to freelists what we did to
tablespaces (automatic space management that obsoletes freelists, freelist
groups and pctused in the way LMTS obsoleted pctinc, initial, next, and
minextents)
What you need to do is set up three tablespaces -- small, med and large. Use a
small extent size on small (say 64k), a med extent size on med (say 512k) and a
big extent size on big (say 5m).
Now, any object you expect to be less then say 50meg, keep it in small. It'll
always have objects with less then 1,000 extents (which is just fine).
Any object you expect to be less then say 250m (but safely up to 500m), put in
medimum. They'll have 500-1000 extents max.
Any object you expect to be 4gig or less -- put into large.
Now, you only have to consider objects bigger then 4gig and treat them special
Hence,
create tablespace tbs_lmt_small
datafile '/d08/oradata/oradb/tbs_lmt_small01.dbf' size 30M
extent management local uniform size 64K;
create tablespace tbs_lmt_medium
datafile '/d08/oradata/oradb/tbs_lmt_medium01.dbf' size 500M
extent management local uniform size 1M;
create tablespace tbs_lmt_large
datafile '/d08/oradata/cmtdb/cmtpers_lmt_indx_medium01.dbf' size 1500M
extent management local uniform size 128M;
Then create your tables:
example: create table emp(empno varchar2(10)) tablespace tbs_lmt_medium;
Hope this helps
Best Regards
Yogeeraj