Sitemap

Amicuk Programming Answers

How to Change Allocation type in tablespaces?

2015-10-11   Views:3

Advertisement

How i can change the allocation type in tablespaces As Source database the table spaces are- SQL> select tablespace_name, status,allocation_type from dba_tablespaces; TABLESPACE_NAME STATUS ALLOCATIO SYSTEM ONLINE USER UNDOTBS1 ONLINE SYSTEM TEMP ONL

How i can change the allocation type in tablespaces
As Source database the table spaces are-
SQL> select tablespace_name, status,allocation_type from dba_tablespaces;
TABLESPACE_NAME STATUS ALLOCATIO
SYSTEM ONLINE USER
UNDOTBS1 ONLINE SYSTEM
TEMP ONLINE UNIFORM
INDX ONLINE USER
TOOLS ONLINE USER
USERS ONLINE USER
PERDBA_TS ONLINE USER
TEMP_PERDBA_TS ONLINE USER
RBS ONLINE USER
9 rows selected.
SQL>
When i created Tablespaces in Target server it's created as -
Target:173.16.3.16
SQL> select tablespace_name, status,allocation_type from dba_tablespaces;
TABLESPACE_NAME STATUS ALLOCATIO
SYSTEM ONLINE SYSTEM
UNDOTBS1 ONLINE SYSTEM
TEMP ONLINE UNIFORM
CWMLITE ONLINE SYSTEM
DRSYS ONLINE SYSTEM
EXAMPLE ONLINE SYSTEM
INDX ONLINE SYSTEM
ODM ONLINE SYSTEM
TOOLS ONLINE SYSTEM
USERS ONLINE SYSTEM
XDB ONLINE SYSTEM
TABLESPACE_NAME STATUS ALLOCATIO
PERDBA_TS ONLINE SYSTEM
TEMP_PERDBA_TS ONLINE SYSTEM
RBS ONLINE SYSTEM
so my question is how i can change the allocation type in target server?
Kindly Suggest
-Sachin

The replay answer
Advertisement
You cannot change extent allocation type. SQL Reference for CREATE TABLESPACE statement http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7003.htm#SQLRF01403 says:
>
After you have specified extent management with this clause, you can change extent management only by migrating the tablespace.

Go to See the other 2 answers

How to Change Allocation type in tablespaces?

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

How i can change the allocation type in tablespaces As Source database the table spaces are- SQL> select tablespace_name, status,allocation_type from dba_tablespaces; TABLESPACE_NAME STATUS ALLOCATIO SYSTEM ONLINE USER UNDOTBS1 ONLINE SYSTEM TEMP ONL[More]

(10gR2) Is there any issue with regard to "Allocation type" of Tablespace?

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

Hi, all. What could be the effects of two "allocation types" of Tablespace in 10g?? .EXTENT_MANAGEMENT --> LOCAL .SEGMENT_SPACE_MANAGEMENT--> AUTO .ALLOCATION_TYPE --> (system, uniform) As you know, oracle recommends "LOCAL" A[More]

To find allocation type in tablespaces

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

Hi, I need to find whether my tablespaces allocation type is automatic. Could anyone please assist me with a query?Hello, You can find all information about your tablespaces with select * from dba_tablespaces;Regards, SylvieRead other 3 answers[More]

Where can i find the allocation type in va01/va02

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

hi, In my requirement, during VA01, I need to get the ARTYP (Allocation type). At what point of sales order creation is this determined and in what structure I can find this value ? If I have it in some structure or global variable which I can access[More]

Tablespace allocation type system  how oracle determines the extent size

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

HI It may be silly question but the I have to ask and get some knowdge Suppose tablespace allocation_type is system then how oracle determins the inital extent and max extent size?Was this tablespace converted to locally managed from an existing tabl[More]

How the storage will be allocated on Undo tablespace made of datafiles?

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

I have a UNDO tablespace with two data files. Wherein one data file with Auto Extend as Yes and other as No. In the case of multiple datafiles in UNDO tablespace, 1. Will the storage be allocated of same size on each datafile ? 2. What will be the ca[More]

Determining Extent Allocation Type

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

Does anyone know how you tell if a tablespace has been configured to use UNIFORM extent allocation or AUTO ALLOCATE . I can see in dba_tablespaces if the extent is dictionary or locally managed. I can also see if it is using ASSM or not but I am stru[More]

Change allocation of tablespace system to uniform

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

Please suugest me to change allocation type of tablespace system to uniform .which command used for do it.Is ther need any or take tablespace offiline ?What are the requirement? Edited by: Ganesh Devadhe on Feb 3, 2013 2:43 PMHi, Sytem tablespace? Ca[More]

How to change "tablespace allocation" Metric chng from 7 days to 1 day?

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

Hi I got to change metric collection time from 7 days (i.e once in every week) to every day. I have not find any tab to modify, please let me know how can I modify. Here are the details. Metric Name: Tablespace Allocation None Sub tabs : Tablespace A[More]

Segments with many allocated extents

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

Dear all, This is regarding the number of allocated extents in any segments. Our environment is SAP ECC 6.0 in ORACLE (11.2.0.2.0) in AIX. We are having 2218 allocated extents for table BSIS in the tablespace PSAP<SID>. The table is 114GB in size an[More]

Email notification doesn't work in a specific tablespace.

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

Hello, I have a Oracle 10gR2 Version: 10.2.0.5.0. I'm having problems to receive emails notifications in a specific tablespace. I created a Rule Notification for "Tablespace Space Used (%)". I know the rule and metrics are ok. How? 1)  At anothe[More]

Hot
I have a scenario where I am trying to Populate TransientVO which is shown has a ADF Read Only Table in page. I have couple of Check Boxes Based on their selection I am trying to render and hide certain Columns. But the Issue which I am facing is onl [More]
Hi, I have installed Stellent 7.5.1 All the components are working fine, if i'm trying to open Workflow i'm getting pop saying this message "unable to start the application workflow. Failed to response from host Server returned HTTP response code:502 [More]
When I press the "submit email" button on my form, it opens Lotus Notes (yes, gag, corporate decision) and appends the XML file to an email that states: "The attached file contains data that was entered into a form. It is not the form itsel [More]
Hi Folks, Could you kindly help me on this matter ? Why on the STS, I'm working on it now, the manager (the position is highest) stll can send for approval ? In my opinion, he should only be able to approve / reject. If I check under that user ID, it [More]
i would like to check the system (i.e. CPU name, CPU speed, etc) of another PC from my PC. How will I do it? Currently, I can check the system of a PC if I launched my java application on that PC. But now, I want it to be checked via network. Can you [More]
Hi, my laptop (Satellite Pro M10-S405 ) has rather recently started prompting me with a message "Built-in HDD Password =" at boot up. I've never set any passwords on the hard disk in the past, I have important data in the HDD. I would appreciate [More]
Hi, We need to upload more than 3000 records to config table related to travel mangement. Is there any way to uplod data as LSMW and BDC may not work? Any help in this regard is highly appreciated. Thanks in advance, LalithI believe you can do throug [More]
I honestly searched this forum for my issue but not having any luck. I need to edit a Dreamweaver site. I created it using a template (.dwt) and it has never given me any trouble until now. For some reason when I edit the template and save the file, [More]
Hello, I am sorry if this post is not in the correct forum but i really don't know where to put it. I need some help with this issue from my work as I am out of ideas and I don¹t find any similar issues on your lists/emails/faqs. I am using a server [More]
Greetings, I am trying to create web links in a dropdown menu, but need some guidance.Horizontal Drop-Menu http://jsfiddle.net/NancyO/zN7fU/ Nancy O.Read other 4 answers [More]