answersLogoWhite

0

What is a Tablespace?

User Avatar

Anonymous

 ∙ 9y ago
Updated: 8/18/2019

physio logical strucutre

User Avatar

Wiki User

 ∙ 9y ago

What else can I help you with?

Related Questions

When a user creates an object without a tablespace clause where will oracle store the segment?

It will go in the default tablespace of the user that creates the object.

How do you rellocate a datafile?

Alter tablespace is the command

What is the difference between tablespace and a table?

A tablespace is a logical storage unit that contains segments, like tables and indexes, while a table is the structure within a database that stores data in rows and columns. Tables are stored within a tablespace, which provides the physical storage for the table's data.

What do you mean by logical schema in database?

tablespace,segment,extent,oracle blocks.. are the logical schema of a database

How to make a Datafile auto extendible?

Yes,use EXTENT MANAGEMENT LOCAL AUTOALLOCATE while creating tablespace.

The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is availble how do you recover the data file?

The data file cannot be recovered.

Why use truncate over delete while deleting all rows?

For performance. Truncate will release the tablespace used by the table that the data is being removed from and delete will not release this space.

What r the differences between 9i 10g oracle in respective of dba?

in 10g sysaux is new tablespace is present in 9i it is now present while in import and export any database in 10g impdp and expdp (data pump ) like facility is present

How do you rename a datafile in Oracle?

â–º Rename a Datafile in Oracle(10g):-SQL> select name from v$datafile; NAME--------------------------------------------------------------------------------/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf8 rows selected.SQL> alter tablespace msb read only;Tablespace altered.SQL> select TABLESPACE_NAME, status from dba_tablespaces;TABLESPACE_NAME STATUS------------------------------ ---------SYSTEM ONLINEUNDOTBS1 ONLINESYSAUX ONLINETEMP ONLINEUSR01 ONLINEUSR02 ONLINETEMP01 ONLINEINNER ONLINEASM ONLINEMSB READ ONLYTEMPORARY ONLINETABLESPACE_NAME STATUS------------------------------ ---------TSPUNDO ONLINE12 rows selected.SQL> alter tablespace msb offline;Tablespace altered.============================================================Work on OS level:-[oracle@abab-YYY-XXX abab]$ CD /u01/app/oracle/product/10.2.0/oradata/nisi/[oracle@abab-YYY-XXX abab]$ lsasm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbfm123.dbf redo2.log system.dbf usr01.dbfredo3.log temporary.dbf usr02.dbf[oracle@abab-YYY-XXX abab]$ cp m123.dbf mmm.dbf[oracle@abab-YYY-XXX abab]$ lsasm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbfm123.dbf redo2.log system.dbf usr01.dbfmmm.dbf redo3.log temporary.dbf usr02.dbf[oracle@abab-YYY-XXX abab]$============================================================SQL> alter database rename file2 '/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf'3 to4 '/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf';Database altered.SQL> alter tablespace msb online;Tablespace altered.SQL> alter tablespace msb read write;Tablespace altered.SQL> select name, status from v$datafile;NAME STATUS------------------------------------------------------------ -------/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf SYSTEM/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf ONLINE8 rows selected.

What is difference between oracle8i oracle9i?

The major differences are- In 9i merge , insert all, case is introduced . In 9i newdatatype called timestamp In 9i you can moniter index using alter index <index name> monitering usage or u can check user_objects table from system user. In 9i new performance monitering tools called STATPACK . In 9i You can dynamically change init ora parameter using alter system <parameter> scope=/path/ of your spfile/pfile In 9i new concept for undo transaction called UNDO tablespace In 9i by default TEMP tablespace is considering while creating new oracle users In 9i new partition called LIST

How do you control number of Data-files one can have in an Oracle database?

The number of data files in oracle database is controlled by the initialization parameter DB_FILES setting this value too high can cause DBWR issues. before 9i maximum no of datafiles in a oracle database is 1022 after 9i and this limit is applicable to the no of data files in a tablespace.

What is inside the collectors edition Franklin Mint monopoly?

Nothing different than from a basic set.. Difference is the quality of the pieces... and possibly the tablespace of the game will be very high end quality wood or at least beter than the cheap stuff. But if its the very high end set.. it can be worth $$.> i would pay $200-$500 for a perfect set tht has the drawers and the pieces are silver & gold.

Trending Questions
Who are the only pitchers to hit home runs in both leagues? What are the public health concerns? How many liters equals 321.5 milliliters? What is a outlier on a number line in math? Who owned the wine-shop in a tail of two cities? What actor played Pat Garrett in the movie Young Guns? What does error 604 on AIM mean? What are some better words besides nice? Was it in victorian times when gravity was invented? Can their arms be a possessive pronoun? What cultural groups are descended from the Celts? Why does brian suddenly realize thathe may be out in the woods for longer than he had anticipated in hatchet? What is another term for moral or lesson of a story? What caused Japanese disunity from the 1300s to the 1500s? In which year was the battle of Trafagar? What are the symptoms and treatment options for bezoar in cats? What does steady beeps mean on a forklift? How do you write 450 thousand in digit? Can a machine increase both the force and the distance over which the force is applied Why or why not? The orthocenter of a triangle may lie outside the triangle because the altitude does not necessairly intersect the?

Resources

Leaderboard All Tags Unanswered

Top Categories

Algebra Chemistry Biology World History English Language Arts Psychology Computer Science Economics

Product

Community Guidelines Honor Code Flashcard Maker Study Guides Math Solver FAQ

Company

About Us Contact Us Terms of Service Privacy Policy Disclaimer Cookie Policy IP Issues
Answers Logo
Copyright ©2025 Answers.com | Lunias Media Inc. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.