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
Boa tarde! Como existe uma tolerância mínima entre o XML do fornecedor e o pedido de compra de R$ 0,02, os usuários solicitaram que este limite fosse alterado para R$ 10,00 (além das tolerâncias que já estão cadastradas na OMR6). Criamos um enhanceme [More]
I keep getting the above problem. The file is not corrupted as It will eventually open after many attempts to clear cache, or registering into the CC. It can be as many as 10 times trying different combinations before it will open the project file. I [More]
After applying this update, I can no longer see or add my HP OfficeJet 8000 to my iMac 27" eith via Bonjour nor USB connected.  Does anyone know how to remove this single update?  I did verify my printers were working after my initial upgrafe to 10.8 [More]
hi all, bought a samsung hd400ld which i found out later had been formatted for windows nt?? just wondering if there is a way of reformatting the hard drive so i can save stuff from my mac onto it?? any suggestions would be appreciated, (have tried u [More]
Hey all, I have a 21" i3 3.06 Ghz iMac. I got it in 2011 and the warranty has expired. Anyway, I notice that every few months after clean installing Snow Leopard, my hard drive would be come corrupt necessitating a complete reinstall of SL again. Thi [More]
Hi, I am using the BOX control command in SapScript. Is it possible to assign the values of Xpos and Ypos dynamicalliy. In BOX XPOS 16 CH WIDTH 0 MM HEIGHT 18 MM FRAME 10 TW, i want to assign the values at runtime, instead of xpos 16 , something like [More]
Lots of people ask about screen spanning and I see a clear answer there...but I am just trying to a find an inexpensive way to monitor my FCP editing projects on a cheap field monitor (or more likely an old television) for color correction purposes. [More]
I want to cull books on my IPad IBook application.  How do I remove a book?The books should be available in your iTunes library on your computer as well. Assuming you have Sync Books selected under the Books tab for your iPad sync preferences with iT [More]
Hello friends can anybody let me what the procedure for implementing the mm module in sap bw from the scratch with some good example ? With regard TusharHi Tushar: Take a look at the documents below. "10 important points to consider while working wit [More]
Hello everybody, some time ago I bought the book by Horstmann and Cornell "Core JAVA 2, Volume I - Fundamentals". Now I decided to start reading it but I don't know what I did with the attached CD. If you have the same book could you kindly send [More]