Server Administration :: How To Change Default XML Storage

Sep 21, 2012

As per the bellow the default XML storage has been changed in 11gr2.

docs.oracle.com/cd/E11882_01/appdev.112/e10492/whatsnew.htm

Quote:
Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle XML DB

The following Oracle XML DB features are new in Oracle Database 11g Release 2 (11.2.0.2).

Default Storage Model for XMLType

The default XMLType storage model is used if you do not specify a storage model when you create an XMLType table or column. Prior to Oracle Database 11g Release 2 (11.2.0.2), unstructured (CLOB) storage was used by default. The default storage model is now binary XML storage.

We have a application which works fine on r1 but not on r2 due to this change, we are going to investigate resolving the issue on the application in the future, in the mean time we need to be able to use the CLOB storage.

Does any one know where we can change this functionality back to the pre 11gR2 change?

View 7 Replies


ADVERTISEMENT

Server Administration :: Default Partition In Table?

Oct 17, 2011

How can i check whether a partition tbale have default partition?

View 9 Replies View Related

Server Administration :: Default Users In Oracle 9i?

May 31, 2010

how many default users available in oracle 9i version.

View 4 Replies View Related

Server Administration :: How To Split Default Subpartition

Oct 12, 2011

I create a range-list partition table using the subpartition template,and there is a default subpartition p_default,when i insert a row which provcode values is 6 into the table,and it belong to the default subpartition,how can i spilt it into a new subpartition such as p_6, and make the row belong to the subpartition p_6?

create table tb_hxl_user_split
(
statedate date not null,
provcode number not null,
usernumber varchar2(13) not null,
rem1 varchar2(1024),
create_date date,
create_by number,
last_update_date date,
last_update_by number
[code]....

View 3 Replies View Related

Server Administration :: Default Count Of Oracle 11g Database

Mar 6, 2011

I installed Oracle 11g and created a test database in that the default count should be 4196... but it is 4143.. some packages are missing.. even when i'm creating materialized view it is showing some error that packages are missing. what can i do for that? Is my oracle s/w corrupted ? even when i downloaded from oracle site it also shows the same count.

View 1 Replies View Related

Server Administration :: WMSYS User That Comes With Default Installation

Apr 20, 2010

A question about the WMSYS user that comes with the default installation :

I've locked it because it has the DBA role. The question is :Will this impact the database?

View 9 Replies View Related

Server Administration :: Deferred Segment Creation - Default True?

Jan 20, 2010

What do you think of this 11.2 parameter? It can give some pretty weird results.

SQL> create tablespace ts1 datafile size 10m;
Tablespace created.
SQL> create table t1 (c1 date) tablespace ts1;
Table created.
SQL> drop tablespace ts1;
Tablespace dropped.
SQL> insert into t1 values(sysdate);
insert into t1 values(sysdate)

[code]...

View 5 Replies View Related

Change Default Datafile Permission (640) To (644)

Mar 15, 2013

How datafile is created with 640 file permission by oracle software.(I know for security reasons it is created with 640 permission)

example:
-rw-r----- 1 orasd dba 104865792 Mar 15 01:17 users01.dbf

I want to change the datafile permission as below. how to change the default value of the datafiles permission from (640) to (644) internally while creating the datafile from oracle side.

example:
-rw-r--r-- 1 orasd dba 104865792 Mar 15 01:17 users01.dbf

View 7 Replies View Related

Forms :: Possible To Change Default Label

Jan 6, 2012

I want to know about that is it possible to change the default label that i.e. "oracle As form service" after run a form.

View 4 Replies View Related

Forms :: How To Change Default Runtime Logo In 6i

Feb 5, 2012

How can I change the default runtime logo in forms 6i.

View 1 Replies View Related

Forms :: Change Color Of Canvas To Default

Apr 12, 2010

The Background colour of the canvas is "gray" i want to change it to default.

View 4 Replies View Related

Security :: How To Change DEFAULT-ROLE Of A User

Jul 13, 2011

I want to change the DEFAULT_ROLE column to NO for following user 'P10_DEMO'.

SQL> show user
USER is "BALA"
SQL>
SQL>
SQL> select name from v$database;

[code]...

how to do this ?

View 8 Replies View Related

How To Change Default Destination Of Backup (archivelogs)

Jan 21, 2013

by default backup area is FRA, It can be change by db_recovery_file_dest FRA contains archivelog ,backupset,datafile,onlinelog folders..

NOW, i specially want to change backup dest. of archvelog to C: (suppose i have C , D, E, F , G) - (i know for archivelogs its log_archive_dest_N command can backup copies to other location but it also goes to default FRA )

backupset to D:
datafile to E:
onlinelog to F:
controlfile to G:
ALL SHOULD CONTAIN ONLY 1 DESTINATION NOT 2 FOR BACKUPS

View 12 Replies View Related

Change Default Value Of Certain Column In A Table In Oracle 11g

Aug 18, 2013

I have a table called cust_file, his table consists of a lot of columns (one of these columns called cus_tax) and have a lot of data,I use oracle 11g, I want to change the default value of the column cus_tax to be equal 1, I wrote   

ALTER TABLE cust_file MODIFY(cus_tax DEFAULT 1); table alteredbut

after I inserted new data to test the operation, I found that the new record has a value

= null for the column cus_taxthen 

I tested using the following query select

data_default from all_tab_columns where table_name='CUST_FILE' and column_name='CUS_TAX'; no rows selected...

Change the default value of the column cus_tax.

View 3 Replies View Related

Server Administration :: How To Change The Character Set

Feb 24, 2012

what's your method,when you want to change the character set ?

View 3 Replies View Related

Server Administration :: How To Change DB Timezone Parameter

Aug 31, 2010

How to change db timezone parameter. My application team has asked me to change the db timzone parameter by following sql.

ALTER database SET TIME_ZONE = '+10:00';

Is this way is the correct one , and do we have any impact on database and does it require a db bounce.

View 2 Replies View Related

Server Administration :: Change Database Character Set?

Jan 25, 2013

Currently my oracle database character set is we8mswin1252 and it is only containing English data as well as spatial data (which is in English of course). I would like to change the Database character set so it could accept Arabic characters.

I have checked the below command on a test DB and it worked fine, but I want to know if it's recommended as a best practice when changing the character set to accept arabic and this won't corrupt my old entered Data ?

SHUTDOWN IMMEDIATE
STARTUP RESTRICT
ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256
SHUTDOWN IMMEDIATE
STARTUP

View 11 Replies View Related

Server Administration :: Change Port Number?

Feb 6, 2013

When I created a new oracle database the port number was 1521 (default), but I want to change it to 1522.

View 4 Replies View Related

Server Administration :: Database Version Change?

Feb 6, 2010

i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard

i need same tablespace,data's everything same as of now.

View 8 Replies View Related

Server Administration :: Can't Change The Parameters Resource_manager_plan

Jul 11, 2011

I can not change the parameters RESOURCE_MANAGER_PLAN, at first, I set the parameters to DAYTIME,but when I restart my db,the parameters hold old values named MAXCAP_PLAN. Why?

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

[code]....

View 5 Replies View Related

Server Administration :: What Will Be The Impact If OS Version Change

Dec 21, 2010

Which config file is used to change the os version(RHEL 4.0 to RHEL 5.5) by OS admin what will be its impact on ORACLE Databases.

View 3 Replies View Related

Server Administration :: 10g Change Disk With Datafiles

Nov 17, 2011

What is best practice to change small disk D:? I am beginner with Oracle. 10g on W2008. 5 datafiles (all indexes,second data file, 2 undotabs)*.dbf (34;30;1;34;12 GB) is on D:. Part of tablespaces (1 data, 1 undo)has files on c:.

I.
1.Shutdown 2008 server.
2.Copy D: image with GHOST to USB, network.
3.Connect new D, create RAID.
4.Restore image to D.
5.Start 2008 server.

II.
1.Stop application.
2.CONNECT AS SYSDBA
3.SHUTDOWN NORMAL or (IMMEDIATE)?
4.Copy files *.dbf at OS level from d: to ... USB disk, network.
5.Shutdown 2008 server.
6.Change disks, create RAID in BIOS.
7.Start W2008.
Is Oracle at this moment in SHUTDOWN mode?
8.Copy back *.dbf to new D: (with directory structure).
9.STARTUP Oracle.

View 1 Replies View Related

Server Administration :: Change SGA_TARGET And SGA_POOL_SIZE Parameters

Aug 31, 2010

When I was going through the Enterprise Manager Grid Control, I found an error due to which I looked at the trace file and it said:

ORA-07445: exception encountered: core dump ACCESS_VIOLATION unable_to_trans_pc PC:0x7C81BD02 ADDR:0x49444E49 UNABLE_TO_READ]

I searched and found that it has something to do with the SGA parameters. I saw that the shared_pool_size and the sga_target paramters are set to 0...Also there are certain SQLs hanging at some point. I thought I should change the above mentioned parameters.

My question now is, can I use the Alter System statements from the SQL Plus to change these parameters, and do they change immediately or do I need to reboot the Oracle instance for those changes to take effect? I would like to do:

alter system set sga_target=400m;
alter system set shared_pool_size=200m;

would these work and take effect immediately?

View 5 Replies View Related

Server Administration :: Trying To Change Tablespace And Datafile Properties On Fly

Aug 21, 2011

This facility has one last 10g database and a very problematic tablespace and last datafile associated with it. The tablespace was set up with INITIAL_ EXTENT of 131,072 (128K) instead of the more 'normal' 4,194,304 (4M) and NEXT_EXTENT of 262,144 (256K) instead of 4,194,304 (4M).

More worryingly, the datafile has INCREMENT_BY set to 1 (8K) instead of 1,280 (10M) or 2,048 (16M).Has anyone ever updated sys.ts$.dflinit and sys.ts$. dflincr to modify the INITIAL_EXTENT and NEXT_EXTENT, and sys.file$.inc to modify the INCREMENT_BY?

View 7 Replies View Related

Server Administration :: How To Alter / Change Size Of Tablespaces

Feb 26, 2013

1-how can i alter/change the size of tablespaces?.

2-is any changing in tablespace size will effect the over all performance?

Tablespace ; Size (MB); Free (MB); % Free; % Used
------------------------------;----------;----------;----------;----------
USERS ; 5; 4; 80; 20
SYSAUX ; 600; 140.875; 23; 77
UNDOTBS1 ; 640; 114.125; 18; 82
SYSTEM ; 700; 28.3125; 4; 96
TEMP ; 64; 0; 0; 100

View 4 Replies View Related

Server Administration :: Uncommit Change And Redo Record?

Feb 22, 2013

SQL> update t set a = 1 where b = 2; -- must have redo record
2 rows updated.
SQL> rollback;

the above redo record that uncommit changed must be written from redo buffer to the online redo logfile. why Oracle write the redo record that uncommit changed to the online redo logfile ? when it will be used?

View 10 Replies View Related

Server Administration :: Renaming Datafile - Change Name In OS Level Also

Nov 3, 2012

While renaming the datafile.

1) ALTER TABLESPACE .... OFFLINE;

2) CHANGING THE DATAFILE NAME IN OS LEVEL;

3) ALTER TABLESPACE .... RENAME DATAFILE 'FILE_OLD' TO 'FILE_NEW';

4) ALTER TABLESPACE .... ONLINE;

In the above steps, I HAD FORGOTTON TO FOLLOW THE 2ND STEP.

At the step of 3rd, i got error message, now i am not able to change the name in OS level Also.

View 19 Replies View Related

Server Administration :: Change Parameter Value In Oracle 11gR2?

May 11, 2012

I want to change cursor_sharing, open_cursors and session_cached_cursors parameter values for SPFILE (Only SPFILE) using SQL Query.

I have found following SQL Queries, but I don't know these queries are only for SPFILE or not.

ALTER SESSION SET cursor_sharing='EXACT';
ALTER system set open_cursors=2500;
ALTER SESSION set session_cached_cursors=70;

I need SQL Queries only for SPFILE.

View 3 Replies View Related

Server Administration :: Change Character Set For Oracle 8i Databases?

Aug 15, 2013

How to change Character set for oracle 8i database. Is there anyway to change the Character set without affecting the current database.

View 11 Replies View Related

Server Administration :: Change Datatype To HEX Notation / Base 64

Jul 10, 2013

I am currently in the process of migrating our database from US7ASCII to AL32UTF8 using DMU.

I am stuck at a point where I have encrypted data that, when the conversion happens, will be destroyed. Oracle suggests to move the data which is currently stored in VARCHAR2 datatype, to a "character set safe way" like hex notation or base64 before converting.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved