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
Ok, so I have searched far and wide and am frankly pretty shocked that I cannot find information on my question/situation: My new wife and I are expecting! Yay!  So, this means that my basically obsolete destop PC is getting eliminated and the comput [More]
I upgraded to QT Pro last week and now when I try to open PDF files with Adobe Reader, QT starts and displays the document. This document can't be zoomed, scrolled, or printed. I have checked for preferences in QT and Reader and can't determine where [More]
I have a new special ledger Z2 setup in 2012.02.01, before that some accounting document are created but not posting to this ledger Z2. now when I transfer old document to Z2, it report error: This document was not posted to any ledger because of cus [More]
Hello I would like to rename a file within an ODI package. Especially, I would use an ODI variable to set the new name of this file dynamically. I tried this with the OdiFileMove with this syntax : OdiFileMove "-FILE=c:/temp/sample.txt" "-T [More]
Hi guys, I recently added a group of pictures to iPhoto that have the wrong date on them. Apparently the camera was set to January 2007. This now means that these photos are in the wrong order in the library. How do I re organise the files so that th [More]
Hi, We was created payslip in R3 smartforms in PDF format. How can I call the PDF file from java web dynpro? Regards, EricHi,    Check [this|http://****************/Tutorials/Smartforms/SFinEPasPDF/Page1.htm] link. Regards, Satyajit.Read other 3 answ [More]
Does anyone know how to create a link to a specific view in a Lotus Notes database using Dreamweaver CS4? Thanks.Hi nehde, To connect lotus notes Database as Data server, you need to confogure the connection Steps: 1. MII Menu -- go to Data servers a [More]
Hi- I have recently purchased an HP Pavillion Touchsmart Laptop 15-P043CL. I want to purchase a simple docking station to allow hook up of printer, larger monitor, keyboard and mouse. I cannot find any information that directly speaks to a product fo [More]
I created my web page years ago in another mac.  I can't update it anymore, but now I need to move it and can't use the old mac.  Help pls. web:  www.jillnanfeldt.comIf you don't have the domain file that was used by iWeb to create the site you'll ha [More]
i have tried unsuccessfully to capture in fcp3 from a digital 8 camcorder (sony 510) using analog hi8 tape... capturing is fine in iMovie... i keep getting an error message looking for timecode and have tried capturing in all three modes unsuccessful [More]