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 all, I just upgrade to gnome 3.2 on 2 machines, for the first one I got a glib2 from AUR so it do not work first (it's now solve) but for the second one I still can't login into gnome. Gdm only show the default wallpaper and a cursor. Here is the [More]
I'm working in a sequence that is full of complex effects and it's all rendered. If I open Item Properties for any clip in this timeline and select logging info and change the label color, FCP will drop the render file. Why would FCP do that? I've be [More]
My station is listed on Itunes Radio stations, but there's a problem with the connection. Does any body help us regarding this issue? The station name is KRAL FM under the Top 40 / Pop categoryMy station is listed on Itunes Radio stations, but there' [More]
Hi, From what I've seen, not too many people used that... but I just noticed that Photoshop CS4 lacks a feature present in previous versions... In CS3, for example, we could click on the Status bar to get a preview of the printed dimension of our ima [More]
Hi, I am facing an error when running a BIM in sm35. The BIM runs fine with my userid in all three modes( foreground,display error mode, background mode)....but fails when the functional person is testing in background mode. The BIM runs fine in all [More]
hp 5512 printer wont print and cartridges are full says i need to replace them but they brand new.  Paper loads but not all way and doesnt feed through and stops saying needs to replace cartridges. TriXsterWhat exactly is the error message?  The docu [More]
Ok Somehow someone put a memory card in my CD drive, am I able to get the memory card out of my CD drive? and will the person be able to get the memory card back? Help Message was edited by: RosalineWelcome to the Apple Discussions! That will probabl [More]
Hi I am using jetty 6_1_8 for creating a Http Server Adapter. I am able to access it in linux but I am getting the following exception in windows java.lang.IllegalArgumentException: name      at sun.misc.URLClassPath$Loader.findResource(URLClassPath. [More]
I would like my iPhone to give a signal every hour (e.g.). Who knows how?On your phone, Clock>Alarm or get an app. Here are a few choices: http://itunes.apple.com/us/app/chime/id414830146?mt=8 http://itunes.apple.com/us/app/timedroid/id399346335?mt=8 [More]
Hi I have developed an applet for JavaCard using JCDK 2.2.1. Following the proceedure described in JCDK user's guide I have created a capfile and from that created script with scriptgen. Now, I am ready to install the applet on a GemPlus GemXplore v. [More]