Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Function of Tablespace in Oracle

Posted on 2004-08-23
3
Medium Priority
?
646 Views
Last Modified: 2011-10-03
What is  the Function of Tablespace in Oracle? write Detail.
0
Comment
Question by:rehman_job
3 Comments
 
LVL 1

Accepted Solution

by:
erhanyayli earned 80 total points
ID: 11893763
Hi

Tablspaces are logical storage objects for storing physical database objects. It gives flexibility and provides a logical design which is independent of the phyical structure.

E.g/  Assume thant you want to create a db table with name t1. And you created t1 on tbs1 which includes data file c:\datafiles\db1.ora

After sometime you wanted to transfer your data to your d:\ drive. if there isn't tablespaces you will have to recreate your table. With tablespaces ypu can transfer your datafiles and that's it. You don't have to worry about the logical db design. Whatever the physical environment it is always same.

Regards,
Erhan
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

886 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