Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL Explain the relationship among database, tablespace and data file.
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
Explain the relationship among database, tablespace and data file.
1 Answer(s)      3 years and 10 months ago
Posted in : SQL


Explain the relationship among database, tablespace and data file.


Advertisement
View Answers

November 19, 2010 at 3:06 PM


Hi,

Here is the answer of your question,

Database : Database is the Collection of data is called database.

Table Space : The table space is useful for storing the data in the database. When a database is created two table spaces are created.

1-System Table Space

: This data file stores all the tables related to the system and dba tables.

2-User Table Space

: This data file stores all the user related tables. We should have separate table spaces for storing the tables and indexes so that the access is fast.

Data Files : Every Oracle Data Base has one or more physical data files. They store the data for the database. Every data-file is associated with only one database. Once the Data file is created the size cannot change. To increase the size of the database to store more data we have to add data file.

Thanks,



Related Tutorials/Questions & Answers:
Explain the relationship among database, tablespace and data file.
Explain the relationship among database, tablespace and data file.  Explain the relationship among database, tablespace and data file.   Hi... data-file is associated with only one database. Once the Data file is created
Insert file data into database
Insert file data into database In this section, you will learn how to insert the file data into database. Description of code: Here we have used FileReader and BufferedReader class to read the file. The data of the file is then stored
Advertisements
Database Tutorial: Introduction to Database Relationships
relationship. If someone is nascent for the subject for database relationship... an association between other entities or factors. Types of Database Relationship It has... and exists between two data based tables. One-to-one relationship
data insertion from xml file to database table
data insertion from xml file to database table  Hi all, I have data in the XML file. I need to insert it into table in the database using servlet. so please reply me . ThankYou
Question about "Insert text file data into Database"
Question about "Insert text file data into Database"  Hey I was reading the tutorial "Insert text file data into Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader
Excel File data upload into postgresql database in struts 1.x
Excel File data upload into postgresql database in struts 1.x  Dear members please explain how Excel Files data upload into postgresql database in struts 1.x
Explain struts.jar file - Struts
Explain struts.jar file   Hi friends am new to java. I read jar file means collection of java files. For executing struts application what are the necessary jar files. " struts.jar " file contains what. can u explain
RelationShip
RelationShip  i have 2 table with one to many relationship how to add in these tables with hibernate please provide me, sample example. example:- one person have many address, when adding person will simply add, and for address
how to display data from jsp file into database
how to display data from jsp file into database  this is a jsp file...+",'"+email+"')"); out.println("Data is successfully inserted into database...+","+ph2+")"); out.println("Data is successfully inserted
Insert XML file data to database
Insert XML file data to database In this tutorial, you will learn how to insert the xml file data to database using dom parser. You all are aware of XML... to read the xml file data and save the values of an XML file to a Database
Insert text file data into Database
Insert text file data into Database In this section, you will learn how to insert the text file data into the database. For this purpose, we have created a 'student.txt' file consisting of students information i.e, id, name, course
Read data from excel file and update database using jsp
Read data from excel file and update database using jsp  read data from excel file and update database using jsp Hi, I am using a MySQL database for scientific research analysis. My team members sends research data in excel file
How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java  Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can
Data needs to be gathered in XML file from the database (MySql) using JSP
Data needs to be gathered in XML file from the database (MySql) using JSP ... data regarding particular id from the database table. Data needs to be gathered in XML file from the database (MySql) using appropriate JSP/Java Bean functions
Retrieve data from the database and write into ppt file
Java Retrieve data from the database & write into ppt file In this section, we are going to retrieve data from the database and write into the .ppt file. For this purpose, we have used Jakarta POI api to create a .ppt file. The class
Retrieve Data from the database and write into excel file
Retrieve Data from the database and write into excel file. In this section, we are going to retrieve data from the database and write into the excel file...); fileOut.close(); System.out.println("Data is saved in excel file
Create XML file from flat file and data insert into database
Create XML file from flat file and data insert into database... have developed an application to create xml file from flat file and data...). Create a file "FlatFileXml.java"  used to create an XML and data
Relationship among Design patterns
Relationship among Design patterns       Patterns have relationships and work together to form a weave. That is why, it is found that more familiar you
What is Digital Relationship?
, consumerism and internet based relationship among people. Digital relationship... and expanse of the term digital relationship. But as we are immersed already... of digital relationship. Digital means concerning digits or numbers and it refers
Insert excel file data into database Using Java Programming
Insert excel file data into database in Java Program In this PHP tutorial section, you will learn how to insert excel file data into the database. We have used Jakarta POI api for inserting excel file data into database in this purpose
J2ME Record Data Base
J2ME Record Data Base       This Application is used to explain how to store data in the database... the RecordStore class. The RecordStore class is used to get the data through
Insert data in Excel File from Database using JSP
the data from database, create an excel file and data insert into newly... Insert data in Excel File from Database  using JSP ... developed a application to insert data  in excel file from database in JSP. We
database data in xml format
database data in xml format  HI, i want to display the database data in the xml format(not as xml file ) on the console using DOM. help will be appreciated. THANKS K.K
How to read data from txt file and save to database MySql - Java Beginners
How to read data from txt file and save to database MySql  Please help me again ,my problem right know is how to read data from txt file then data... into database visit to : http://www.roseindia.net/tutorialsearch/?t=file
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database... a browse button which can upload a excelfile and after uploading the data should be inserted into oracle database.. please help me sir...   hi friend
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.
How to display data fom MySQL DataBase-table in to JSP file by submitting... DataBase/DB Name:lokesh; Table Name:TR_list; columns:nodename,packageno,TR... to create a viewTR.jsp file in netbeans IDE, where i have to : 1.connect to DB
selecting data from database
selecting data from database  how to select data from database using Dao in struts   Hi, You have to load the data from database using hibernate and send the data in a Java file object to jsp page. Please read at http
JSP Get Data Into Dropdown list From Database
JSP Get Data Into Dropdown list From Database In this section we will discuss.... This tutorial explains you that how to fetch data from database and set... data from the database and set it into the dropdown list in JSP using MySQL
how to show data in database ?
how to show data in database ?  how to show the data in the database to the user in the textbox so that user can modify it and save it again
Insert database values in the file
Insert database values in the file In this section, you will learn how to retrieve the data from the database and insert into the file. Description of code... the values from the database and store them into the file
Saving data in database
Saving data in database  hello i m facing a strange problem if i am submitting data form database then i can see it in database but if am submitting from app then it is not showing in to database but when i fetching form
Advertisements
 

 

 

DMCA.com