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
Windows 7 Pro, Office 2013 Home and Business I don't see a registry key for the plugin, there's no properties in Outlook for the plugin Manually loads properly and functions properly, however unable to configure it to load when Outlook starts. Any id [More]
Hi, I am a new member of this forum. I am working with a problem we got a few weeks ago. It is from a Pro C batch executable running on 10 threads dealing with >800 data accessed from multiple tables. The error as reported came from a package.functio [More]
I've posted this to the SCCM 2012 forum and only received one response so far that states that this is a known issue that has been discussed before and isn't easy to fix;  I was not given any actual solution either.  Since this involves SSRS I though [More]
i have a mid 2007 mac book pro and i cant get mac osx mountain lion please get back to me and it says on the apple website i would be able to get itI would make sure it's deffinetely a mid 2007, and that's not just when you purchased it. Also you nee [More]
Hello All, Assume I have a table of N rows with two columns. I will have one checkbox on column-1 and zero or more on column-2. Column-1 may represent categories and column-2 represents associated things. Just like below: Column 1 Column 2 Books HFSJ [More]
I'm running vista 64 bits in french with IE 8 When trying to convert a text to speech, captivate is unable to do so. Thanks' for any input.For anyone looking at a solution here it goes... 1. Close Captivate 2. Open command prompt "As administrator&qu [More]
Hello everyone! I think this is a great forum so I decided to post here. You know, this problem is very popular and here are many posts like this. The trouble was that when I imported AVCHD video from my Sony HD camera (DVD) the quality was lower and [More]
I am a multimedia design student working on an interactive educational program for a local company. I took this project for the opportunity to learn more about Director than was covered in our class, which wasn't much. The project they have given me [More]
hi all i am creating my forms in developer 9.0.4 my Application server is Linux so when i am trying to compile the fmb files in linux it doesnt work and i get the error cant create file but if i open the file in the developer in linux and save it und [More]
Because I'm scanning slides and Lightroom apparently cannot add capture dates and the like, I am using exifer to write metadata to my scans. I first load them into Lightroom and then import XMP metadata. I load them first so I can see them while I de [More]