1. Do you know in which tablespace the tables that store information about the Oracle

valexena

1. Do you know in which tablespace the tables that store
information about the Oracle online rollback segments is
located?
--
Posted via http://dbforums.com

Jul 19 '05 #1

Subscribe Post Reply

3576

Mark D Powell

valexena <me*********@dbforums.com> wrote in message news:<35****************@dbforums.com>...

1. Do you know in which tablespace the tables that store
information about the Oracle online rollback segments is
located?

The answer to your question would be the SYSTEM tablespace and memory
(SGA). See the Oracle version# Reference manual.

The following articles may help
How do I find information about a database object: table, index,
constraint, view, etc… in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

HTH -- Mark D Powell --

Jul 19 '05 #2

Austin

valexena <me*********@dbforums.com> wrote in message news:<35****************@dbforums.com>...

1. Do you know in which tablespace the tables that store
information about the Oracle online rollback segments is
located?

If I understand you correctly the answer is the SYSTEM tablespace. All
the base tables used by the data dictionary views should be in the
SYSTEM tablespace, and obviously this includes DBA_ROLLBACK_SEGS etc.

Jul 19 '05 #3

Similar topics

Oracle tablespace management

by: Srini | last post by:

In our Oracle installation on SCO Unix, we have reached almost 100% of tablespace allocated to Oracle. Now we have deleted a large table from the database after taking backup elsewhere. Now if we...

Oracle Database

Oracle 9 - tablespace default storage

by: Jens H. Hamann | last post by:

Hi, I am having a strange problem with the storage parameters in Oracle 9.2.0.1 database. I create a tablespace with some default storage parameters but when i am adding a table to the tablespace...

Oracle Database

LONG RAW AND #TABLESPACE

by: M Bouloussa | last post by:

Hi, can you help me ? My problem is : I have two tablespaces (sdata0 and sdata1) On the first tablespace (sdata0) I would to store all the data except long raw data and on the second...

Oracle Database

tablespace SYSTEM used by others user, not sys. Help!

by: tracy | last post by:

hi, i need advise and guidance from experts. Today, I discovered about 1464 tables created in SYSTEM tablespace and the owner is dev_user. As, i read from ORACLE 101 DBA's it said :'System...

Oracle Database

Which tablespce is used when running ALTER TABLE & CREATE INDEX

by: maricel | last post by:

Could someone confirm which tablespace is being used when running ALTER & CREATE INDEX. Is it the tempspace or the tablespace where the table resides? Many thanks, maricel

DB2 Database

Restoring a Tablespace level backup to another database

by: wanchan | last post by:

Dear all, Is it possible to restore some (not all) tablespaces to a new database? We have a full offline backup, and as the manual says, we can restore the whole set of tablespaces to a new...

DB2 Database

Tablespace - mysteriously lost pages.

by: Konstantin Andreev | last post by:

Hello, all. Let the tablespace SY810T4K is almost full: --------------- db2 =list tablespaces show detail ... Name = SY810T4K Type = Database managed space Contents...

DB2 Database

Dropped Tablespace

by: Ravi Padmakar | last post by:

Hello, In the process of making my database work (I started with not being able to insert records because of tablespace issues) , I dropped the tablespace for it. Now I am not able to access the...

DB2 Database

1. Do you know in which tablespace the tables that store information about the Oracle

by: valexena | last post by:

1. Do you know in which tablespace the tables that store information about the Oracle online rollback segments is located? -- Posted via http://dbforums.com

Oracle Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA