
	Where results make sense

Topic: Tablespace

In the News (Sun 27 Dec 09)

Northern Trust

Marvin Harrison

Peter Chernin

Gary Locke

Match Play

Penelope Cruz

Mickey Rourke

AR Rahman

Danny Boyle

Hugh Jackman

	Tablespaces [Oracle]
		A tablespace, in turn, consists of at least one datafile which, in turn, are physically located in the file system of the server.
		Dropping a tablespace is a structural change to the database that requires a backup.
		The extent size of the objects in the tablespace are subject to the tablespace's minimum extent size.
	www.adp-gmbh.ch /ora/concepts/tablespaces.html (831 words)

	SQL Statements: ALTER TABLE to ALTER TABLESPACE, 3 of 3
		The tablespace must not be involved in an open backup, because the end of a backup updates the header file of all datafiles in the tablespace.
		to indicate that the tablespace is to be converted from a temporary to a permanent one.
		to indicate specifies that the tablespace is to be converted from a permanent to a temporary one.
	www.stanford.edu /dept/itss/docs/oracle/9i/server.920/a96540/statements_33a.htm (1542 words)

	Tablespace Standards
		The HOT tablespace resides on a Solid State Disk(s) (SSD).
		As a result, access to tables within the HOT tablespace are not subject to the normal limitations of disk-based tablespaces, as SSDs run at memory speeds.
		The TEMPTABLES tablespace is used as a general scratch area for SQL statement processing by Oracle.
	www.oberlin.edu /acs/backup/team/doc/or_standards/TSpaceStandards.html (544 words)

	Oracle 8i Transportable Tablespaces
		In this example transport tablespace may or may not be feasible depending on the number of tables in the tablespaces that are not required in the DSS database.
		If on the other hand more tablespaces are used to contain the large number of application tables it may be more feasible to copy a set of tablespaces to the DSS environment even though all of the tables will not be used for an ODS or datagroups.
		If some or many of the tablespaces are allocated with a significant amount of free space then transferring tablespaces could require a conisiderable amount of free space on the target DSS machine or node to accomodate the physical file transfer.
	www.indiana.edu /~dss/Services/DataWarehouse/Oracle/tablespace.html (1606 words)

	Module 4 - Oracle Tablespaces and Datafiles
		A tablespace belongs to only one database, and has at least one datafile that is used to store data for the associated tablespace.
		All segments created in the tablespace will inherit the default storage parameters unless their storage parameters are specified explicitly to override the default.
		Example continued: This code changes the database's default temporary tablespace to TEMPGRP – you use the same command that would be used to assign a temporary tablespace as the default because temporary tablespace groups are treated logically the same as an individual temporary tablespace.
	www.siue.edu /~dbock/cmis565/module4-tablespaces_and_datafiles.htm (2365 words)

	TableSpace
		Tablespace names must be unique in the database.
		The number should be an average for all containers that belong to the tablespace, if not the same for all containers.
		The number shouldbe an average for all containers that belong to the tablespace, if not the same for all containers.
	ws.apache.org /jaxme/apidocs/org/apache/ws/jaxme/sqls/db2/TableSpace.html (903 words)

	SQL Command and Function Reference - DBMaker Online / Manuals
		Autoextend tablespaces are tablespaces that automatically increase in size (to a maximum of 2 GB) to hold additional data when required.
		You cannot add new files to an autoextend tablespace unless you first convert it to a regular tablespace, with one exception: if an autoextend tablespace is created with only one data file and no BLOB file, you may add a single BLOB file at a later time.
		You may want to change a tablespace from autoextend to regular when a tablespace has grown to fill all available space on a disk and you want to add additional files on another disk, or when you want to restrict the amount of disk space a tablespace will occupy.
	www.dbmaker.com.tw /reference/manuals/sql/commands/altertablespace.html (1299 words)

	Tablespaces and Datafiles
		The size of a tablespace is the size of the datafile(s) that constitute the tablespace; the size of a database is the collective size of the tablespaces that constitute the database.
		For a tablespace that uses the data dictionary to manage its extents, Oracle updates the appropriate tables in the data dictionary whenever an extent is allocated or freed for reuse.
		If the tablespace containing the tables is offline, the table data in the database is not accessible because the tables are required to access the data.
	www.cs.umbc.edu /help/oracle8/server.815/a67781/c03space.htm (3570 words)

	nanda on 10g tablespace for OTN
		Important note: the default tablespaces of all users with the old tablespace are changed to , even if something else was specified explicitly for some users.
		If there are two tablespaces with the same name, the segments in the target tablespace must be moved to a different one and the tablespace recreated—a task easier said than done.
		Oracle8i introduced the table move from one tablespace to another, Oracle 9i Database R2 introduced the column renaming, and now—the last frontier—the renaming of a tablespace itself is possible.
	www.rampant-books.com /art_nanda_ts.htm (1170 words)

	Recover database from only tablespace backups
		As long as the catalog tablespace is one that is restored, you can complete the restore process at any time, roll forward to the point you want to get to and then open the database up for access.
		Any tablespace that has not been restored (but was part of the database when you did the tablespace backups) is put into a restore pending state.
		At this point you have three options, you could drop the tablespaces if they are no longer needed, you could restore them at any time, and then roll them forward to a point of consistency, or you could just leave them in restore pending state and deal with them later.
	blogs.ittoolbox.com /database/technology/archives/recover-database-from-only-tablespace-backups-10194 (1240 words)

	Oracle Bigfile tablespace tips
		A bigfile tablespace (BFT) is a tablespace containing a single file that can have a very large size.
		The traditional tablespace is referred to as a smallfile tablespace (SFT).
		It allows you to create a bigfile tablespace of up to eight exabytes (eight million terabytes) in size, and significantly increase the storage capacity of an Oracle database.
	www.dba-oracle.com /t_bigfile_tablespace_tips.htm (561 words)

	Introduction to the Tablespace Map
		Once a tablespace analysis has been performed, a Tablespace Analysis report is created and provides a detailed listing of any detected problems and marks the problematic segments with a warning or alert flag.
		Extents in the tablespace that have not been assigned to any segment are displayed in white.
		Even though the performance of database access and transaction operations on a segment is generally unaffected by the number of extents, a maximum of 1024 extents is recommended to ensure efficient handling of certain DDL operations such as dropping or truncating a table.
	www.mcs.csuhayward.edu /support/oracle/doc/9.2/em.920/a86647/extent.htm (1471 words)

	Free User Tablespace
		But when you delete the user the space is not released for that user from the users tablespace.
		It should be possible to examine the user before removal, and check the sizes of all the objects in their schema, thus getting the size required for the shrinkage...
		This would save you, in that you could simply drop the tablespace when the user/schema is dropped.
	www.experts-exchange.com /Databases/Oracle/Q_21116385.html (1058 words)

	Super-Sizing A Database: Oracle 10g Tablespace Enhancements
		Tablespaces live in that lonely place between the physical raw data contained in their datafiles and the myriad logical objects whose structure they organize, manage, and control: tables, indexes, and LOBs, to name just a few.
		A tablespace is limited to a maximum of 65,536 (64K) datafiles, but each datafile's size had been limited by the maximum OS file size.
		Since BIGFILE tablespaces are allowed to own only one datafile, there is now a one-to-one correspondence between tablespace and datafile, and database space management actually becomes much simpler because all space management operations that were only limited to datafiles now extend automatically to BIGFILE tablespaces.
	www.databasejournal.com /features/oracle/article.php/3559291 (2371 words)

	RC_TABLESPACE
		This view lists all tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations.
		The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
		The SCN recorded when the tablespace was dropped.
	www.stanford.edu /dept/itss/docs/oracle/10g/server.101/b10770/rcviews31.htm (154 words)

	CREATE TABLESPACE
		Use this clause to determine whether the tablespace is a bigfile or smallfile tablespace.
		Use this clause to create a locally managed temporary tablespace, which is an allocation of space in the database that can contain transient data that persists only for the duration of a session.
		When a temporary tablespace, or a tablespace group of which this tablespace is a member, is assigned to a particular user, then Oracle Database uses the tablespace for sorting operations in transactions initiated by that user.
	www.stanford.edu /dept/itss/docs/oracle/10g/server.101/b10759/statements_7003.htm (2922 words)

	10 Managing the Undo Tablespace
		Now, you use the undo tablespace method, and you are said to be operating in the automatic undo management mode.
		You cannot use both methods in the same database instance, although for migration purposes it is possible, for example, to create undo tablespaces in a database that is using rollback segments, or to drop rollback segments in a database that is using undo tablespaces.
		This parameter should be used only when the database has multiple undo tablespaces and you want to direct the database instance to use a particular undo tablespace.
	download-west.oracle.com /docs/cd/B13789_01/server.101/b10739/undo.htm (3744 words)

	DBAzine.com: Temporary Tablespace
		It is created implicitly when the first temporary tablespace is assigned to it, and is deleted when the last temporary tablespace is removed from the group.
		It allows multiple default temporary tablespaces to be specified at the database level.
		It follows the concept that a tablespace and a datafile are logically equivalent.
	www.dbazine.com /olc/olc-articles/ault2 (1043 words)

	Task - Increase the tablespace size
		Since Vista's tablespaces are created with a fixed maximum size, we must add additional datafiles to allow them to grow further.
		This message doesn't necessarily mean a tablespace is full, but there is a good chance it is the case.
		It is a good policy to add a new datafile, for example, when less than 2 GB remains on a datafile for one of the tablespaces that have a limit of 4 GB per datafile.
	open-systems.ufl.edu /services/webct-vista/maint_docs/task_incr_tablespace.html (353 words)

	HOWTO:Delete datafile from Tablespace - ITtoolbox Wiki
		Sometime we need to delete datafiles belongs to a Tablespace in this case we can not do this as simple way it should be.
		But since you may not want to lose the information in the tablespace before dropping it, take an export backup of the tablespace info, drop the tablespace, recreate tablespace and import back.
		The typical recommended procedure is drop and recreate the tablespace.
	wiki.ittoolbox.com /index.php/HOWTO:Delete_datafile_from_Tablespace (401 words)

	DBAsupport.com : Oracle 10g Central : Oracle 10gR2 Transportable Tablespace Enhancements, Part 2: Tablespace Versioning ...
		These tablespace versions can be stored within the same Oracle 10gR2 database that typically needs to "plug in" the selected version of the tablespace; however, they can also be stored in a remote Oracle 10gR2 database to provide a central repository for retrieval of tablespace versions for direct plug-in" to any other Oracle 10gR2 database.
		With tablespace versioning, I can now simply create versions of the affected tablespace sets just before the application changes are deployed, and that gives me a fallback position in case my application developers and quality assurance analysts have completely dropped the ball during their development and testing efforts.
		I can then easily "plug in" just the needed versions of the tablespace(s) to an auxiliary instance, give my users access privileges to that auxiliary instance, and once their reporting requests are complete, I can just as easily "unplug" the tablespace versions from the auxiliary instance.
	www.dbasupport.com /oracle/ora10g/transportable_tablespace02.shtml (3040 words)

	Creating PowerBuilder Catalog Tables in a Specified Oracle Tablespace Tips: Development - Sybase Inc
		When this tablespace becomes fragmented, it is more problematic to defragment compared with other tablespaces.
		Historically, since this user had to be SYSTEM, the tables are usually created in the SYSTEM tablespace.
		If you are using PowerBuilder 6, 7 or 8, you may also change the schema references from SYSTEM to the schema of you choice.
	www.sybase.com /detail?id=44537 (577 words)

	DBAzine.com: Inside Oracle9i Tablespace Management
		It is important to note that LMT and ASSM are optional and are used in the same instance with "traditional" tablespaces.
		While it is possible for Oracle9i to detect the average row length for segments in a bitmap managed tablespace, Oracle9i has no way of predicting how much space to reserve of each data block for row expansion.
		Since the extent size is controlled by Oracle9i locally-managed tablespaces, each extent size within the tablespace is uniform, regardless of the NEXT extent size for each object in the tablespace.
	www.dbazine.com /oracle/or-articles/burleson11 (2809 words)

	ORACLE - DBA Tips Corner
		A Locally Managed Tablespace is a tablespace that manages its own extents by maintaining a bitmap in each datafile to keep track of the free or used status of blocks in that datafile.
		While free space is represented in a bitmap within the tablespace, used extents are only recorded in the extent map in the segment header block of each segment, and if necessary, in additional extent map blocks within the segment.
		If the tablespace is expected to contain objects of varying sizes requiring different extent sizes and having many extents, then AUTOALLOCATE is the best choice.
	www.idevelopment.info /data/DBA_tips/Tablespaces/TBS_1.shtml (1163 words)

	Oracle tablespace fragmentation
		Buried in the Oracle documentation is a procedure for converting a tablespace's extent management from dictionary to local or vice-versa.
		There are a few restrictions on these conversion procedures (for example, 9i UNDO tablespaces currently cannot be converted, etc.), so you should check the Oracle documentation for the specifics of using these new procedures.
		Also, note that converting a dictionary-managed tablespace that has existing objects to local will not magically rebuild all the existing object extents to conform to the sizing guidelines used by locally-managed tablespaces.
	www.dba-oracle.com /bp/teaser_rs_ts_frag.htm (577 words)

	ORACLE - DBA Tips Corner
		If the increase in size of the temporary tablespace (the tempfiles) gets exceedingly large because of a particular anomaly, the DBA will often want to resize the temporary tablespace to a more reasonable size in order to reclaim that extra space.
		Several methods exist to reclaim the used space used for a larger than normal temporary tablespace depending on which release of Oracle you are running.
		In cases where the temporary tablespace you want to resize (using the drop/recreate method) is the default temporary tablespace for the database, you have several more steps to perform, all documented below.
	www.idevelopment.info /data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml (1089 words)

	MySQL AB :: MySQL 5.1 Referenzhandbuch :: 14.2.3.1 Verwendung von Tabellen-Tablespaces (ein Tablespace pro Tabelle)
		Multi-Tablespaces sind praktisch für Benutzer, die bestimmte Tabellen auf separate physikalische Platten verlagern oder Backups einzelner Tabellen rasch wiederherstellen möchten, ohne die Arbeit mit den übrigen
		Entfernen Sie die Option wieder und starten dann den Server neu, werden die neuen Tabellen im Shared Tablespace angelegt, aber Tabellen, die mit Multi-Tablespaces angelegt wurden, bleiben weiterhin zugänglich.
		benötigt immer den Shared Tablespace, da es sein internes Data Dictionary und seine Undo-Logs dort speichert.
	www.ncsu.edu /it/mirror/mysql/doc/refman/5.1/de/multiple-tablespaces.html (379 words)

Try your search on: Qwika (all wikis)