Sitemap

Amicuk Programming Answers

How to determine the object in the tablespace

2015-10-11   Views:0

Advertisement

Hi I have a problem with my database, How can i determine the object in the tablespace and how do move old tablespace into new tablespace and how to drop existing tablespace. ThanksHi, If you want to find for all objects information, you can use dba_

Hi
I have a problem with my database, How can i determine the object in the tablespace
and how do move old tablespace into new tablespace and how to drop existing tablespace.
Thanks

The replay answer
Advertisement
Hi,
If you want to find for all objects information, you can use dba_segments and filter this against the tablespace name. Once done you can create another tablespace and move the objects from old tablespace to new tablespace. Later you can drop the old tablepspace. You can use the below mention commands also:
SELECT 'ALTER TABLE '|| table_name ||' MOVE TABLESPACE USERS;'
FROM user_tables WHERE tablespace_name='MY_TableSpace';
SELECT 'ALTER INDEX '|| index_name ||' REBUILD TABLESPACE USERS;'
FROM user_indexes WHERE tablespace_name='MY_TableSpace';
SELECT 'ALTER TABLE '|| table_name ||' MOVE LOB ('
|| column_name ||') STORE AS (TABLESPACE USERS);'
FROM user_lobs WHERE tablespace_name='MY_TableSpace';
On the other hand,
You can also export a backup of the source tablespace and import into the target tablespace.
Regards,
XIC

Go to See the other 4 answers

How to determine the object in the tablespace

Category:DefaultRelease time:2015-10-11Views:130

Hi I have a problem with my database, How can i determine the object in the tablespace and how do move old tablespace into new tablespace and how to drop existing tablespace. ThanksHi, If you want to find for all objects information, you can use dba_[More]

Determine all objects that a group has been assigned to

Category:DefaultRelease time:2015-10-11Views:130

I am trying to determine all objects that a group has been assigned to. For example, I would like to know what communities and portletes a group has been assigned to. I can retrieve the information directly from the plumtree database, however, I have[More]

Move objects from one tablespace to another

Category:DefaultRelease time:2015-10-11Views:130

Hello Running Oracle 10g rel 2 and I would like to move all objects from one tablespace to another. There are Primary Key indexes to other tables in this tablespace. The size grew too large and I want to reduce the size. Thank you.Good afternoom Sir![More]

To capture all the objects from an tablespace and restore.

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have a situation in the  Schema  refresh process where i may have  to delete a tablespace  and its datafiles. Then I have to recreate it as it was before and restore all it objects . Is there any way that i can capture all the objects of th[More]

Moving objects from USERS tablespace

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I want to clean my database and this involves moving all objects from USERS tablespace to their respective tablespaces. I have following types of objects in my database: INDEX INDEX PARTITION INDEX SUBPARTITION LOBINDEX LOBSEGMENT TABLE TABLE[More]

Moving objects into different tablespaces

Category:DefaultRelease time:-0001-11-30Views:130

Hi Gurus, Here is my query . I have 40gb space to have dataset from production database. Test enviornment will be refreshed with production database. From testing enviornment development will be refreshed to aviod any connections to production. As pa[More]

[svn:fx-trunk] 7073: When looking around a tab group to determine which object to focus on, not only should the object be selected, but it should also be enabled and visible.

Category:DefaultRelease time:-0001-11-30Views:130

Revision: 7073 Author:   [email protected] Date:     2009-05-19 08:27:59 -0700 (Tue, 19 May 2009) Log Message: When looking around a tab group to determine which object to focus on, not only should the object be selected, but it should also be enable[More]

BAdI: Determine Target Object in BE System

Category:DefaultRelease time:-0001-11-30Views:130

Hi all We have recently done an upgrade to SRM 5.0 and I realised that the BAdI for determining target object is different. In the EBP 3.5 system in the SPRO, the BAdI name was BBP_TARGET_OBJECT. It seems that the BAdI name is now BBP_TARGET_OBJTYPE.[More]

Objects of a tablespace

Category:DefaultRelease time:-0001-11-30Views:130

Hi, 1-how can I see the objects of a tablespace ? 2-does TEMP tablespace contain any object ? How to see ? Thanks.Many thanks but : SP2-0734: unknown command beginning "'free spac..." - rest of line ignored. SP2-0734: unknown command beginning &[More]

How to find objects in a tablespace?

Category:DefaultRelease time:2015-10-11Views:130

Is there a possibility to find out all objects, that are placed in one tablespace?select owner, count(object_name) from dba_objects where object_type = 'TABLE' group by owner; nullRead other 2 answers[More]

Objects in a tablespace

Category:DefaultRelease time:2015-10-11Views:130

Hai all, How to findout the largest object and its size in a particular tablespace ? is there anyway we can list out that ? Thanks Yusufobjects of a tablespace List objects in tablespace may be helpful to you.Read other 3 answers[More]

Hot
hi experts, I m new to BW, i m facing a problem of aggrgating the fields in my DSO. i have 2 fields in DSO1 with 100 records. i have another 3 fields in DSO2 with 300 records. Now i want to unite the records from these two dso into a new dso having 5 [More]
Hello all, I am a sysadmin at a 3 campus school, and am trying to extend our AD schema to include Exchange 2013 attributes so that we can configure groups synced to Office 365 using DirSync. However it keeps failing at the same point each time. I hav [More]
I am using JDeveloper 10 to make a jsp page that is a form full of inputs and buttons. JDeveloper then creates the setters and getters for you for the ids of the various inputs and buttons. I also have used JDeveloper to create a backing bean. The id [More]
Hi Everyone, I hope this hasn't been brought up a gazillion times. I'm wondering if its possible to setup a calendar that both my wife and i can have access, edit and add items from two different machines? I have access to setting up WebDav on a serv [More]
Hi Everyone, I have setup a form in CS5 have the input sent to me with a script.  It all works fine in IE 8, Firefox 12.0, Safari 5.1.2 for PC, but I do not get the email when using Chrome. I have the form page working on my website but the page itse [More]
Hy there... I've got some nice little problems with the Adobe Reader 9.3.0. When i start it as a user with roaming profile, it crashes befor the splashscreen is shown. After update to 9.3.2 still the same problem. But only with users which have roami [More]
I have restart, restored, and it still didn't fix the problemIf you are still having this problem after restoring to factory settings/new iPod (you did not say what restore you did) that indicates a hardware problem and an appointment at the Genius B [More]
all of a sudden today I tried to print a PDF file and the font is huge and only a portion of the page is printing. Never had an issue until today can someone helpFrom the Print Dialog, is page scaling set to None? What version of Acrobat; 8, 9, X Rea [More]
Dear all, I am getting following error in my package; Message: com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30066: All child sessions have failed      at com.sunopsis.dwg.tools.WaitForChildSession.actionExecute(WaitForChildSession.java:27 [More]
RE: Firmware v2.00.02 & Driver v1.672 Update dated 06/04/06 for Megaplayer 533 - Model MS5533. I think that there is a possible problem with the above Driver & Firmware Versions as they do not seem to work for the Mega Player 533 - Model MS5533 ?? [More]