SQL & PL/SQL :: Does Oracle Support Domain Concept
Dec 8, 2011Do Oracle SQL support Domain Concept?
View 3 Replies
ADVERTISEMENT
Oracle Database Concept - Transactions
Nov 6, 2011How a DB client session establishes a connection and how it performs any transaction.
View 1 Replies View RelatedNetworking And Gateways :: ISP Concept In Oracle?
May 29, 2012what is ISP concept in Oracle10g???
View 2 Replies View RelatedBackup & Recovery :: Log File Concept In Oracle
Dec 10, 2011what is the process of creating log file in database, Suppose if we have two user ,and both are logon through id & password,at that condition i want all log file from users who done at the database like any events.
View 1 Replies View RelatedInstall Oracle E-Business Suite R12 On Mandriva - Domain Name?
Sep 9, 2010I want to try installing Oracle E-business suite on Mandriva But when I try e.g. domainame I get blank.
A) How can I check my domainname ?How can I set it?Here is the hosts file
[Select all] [Show/ hide]
127.0.0.1 localdomain
192.168.0.2 david.domain.com david
Server Administration :: Error In Domain Name - Oracle Installation
Apr 22, 2011When Oracle was installed, there was an error in the server's domain name (missing a "."). Is there an easy way to fix this domain name in the Oracle installation after the fact? I know about tnsnames.ora, pfile, system parameters, and I'm pretty sure I can do emagent -config. My concern is that the "Installed Products" would not like the fact that the domain name is now "abc.proj.org" when installation was done on "abcproj.org". The /etc/hosts file had "abcproj.org", and we want to fix it to "abc.proj.org".
I need to reinstall Oracle -- is there a better way?
Forms :: How To Get Domain Name Using Webutil From 10g And Oracle Application Server Name
Apr 29, 2010How can i get my domain name using webutil. from forms 10g.
View 8 Replies View RelatedServer Administration :: Changing Oracle 11g From Workgroup To Domain
Jul 24, 2013I am using oracle 11g in window server 2008 R2 enterprise under WORKGROUP. And it was working fine. But after changing it from WORKGROUP to DOMAIN not able to connect it.
Its comes as
ORA-12505:TNS:listener does not currently know of SID given in connect description.
How To Get Profile In Oracle Support
Nov 19, 2012How to get my profile in oracle support ? i need to know to many license what we have in oracle how to get this ,ex: oracle rac 11g , application server 10g ...etc.
View 13 Replies View RelatedForms :: Creating Domain Failed While Configuring Oracle Instance?
Feb 14, 2013I have installed Weblogic Server 10.3.6 in my PC .While in installation i have chosen 'Custom' option instead of 'Typical' and Unchecked software Components 'Database Evaluation' and 'Oracle Coherence' and Installed 'Node Manager Service' then continued with Weblogic server installation .Weblogic Server installed Succesfully.
(In weblogic server home folder nodemanager.domains file also not created after weblogic server installation)
Now i started installation of Forms and Reports 11g R2 . While Configuring Instance 'Domain Creation is Failed'.
Forms :: Firefox 14.0 Can Support Oracle 10g
Jul 9, 2012firefox 14.0 can run oracle 10g forms ? and how can run ?
View 7 Replies View RelatedWindows :: Does Win 7 Support Oracle 11g To Install
Nov 16, 2011that windows7 will support oracle 11g and oracle 10 g
View 1 Replies View RelatedText :: Index For Domain Index With Composite Domain Index (CDI) Very Slow
Jun 27, 2012I am on 11.2.0.3 Enterprise Edition. We are using the new feature "Composite Domain Index" for a Domain index on a very large table (>250.000.000 rows). It really works with mixed queries. We added two number columns using FILTER BY.We have lots of DML on this table. Therefore, we are executing synchronize and optimize once the week. The synch behaves pretty normal. But "optimize_index" takes a very very long time to complete. I have switsched on 'logging' for the optimize process. The $I table takes some time but is finished normally. But the optimization of the $S table (that is the table created for the CDI feature) is running over 12 hours now - and far from being finished. From the logfile, I can see that it optimizes 1000 rows every 20 minutes. Here is the output of the logfile:
Oracle Text, 11.2.0.3.0
14:33:05 06/26/12 begin logging
14:33:05 06/26/12 event
14:33:05 06/26/12 process $N for optimize: SEQDEV.GEN_GES_DESCRIPTION_CTX_I
14:33:16 06/26/12
14:33:16 06/26/12
[code]....
I haven't found a recommendation from Oracle not to use "optimize_index" for Domain Indexes with CDI. But in my case, it would be much faster just to drop and recreate the Domain Index in question.
Server Administration :: IP Address / Host Name Or Domain Of Oracle Database Servers
Mar 27, 2012Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.
View 3 Replies View RelatedForms :: Oracle 10g Express Edition Can Support 6i
Mar 2, 2007I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.
If there is any patch to connect forms 6i into oracle 10g express edition.
Does Oracle 11g Support Host Naming Method
Jun 30, 2013DB: 11.2.0.3 & OS: RHEL5 Easy Connect Naming method enhances the host naming method by allowing for a port and service specification. My question is does Oracle 11g support Host naming method?
View 4 Replies View RelatedSQL & PL/SQL :: Creating Oracle Database To Support Chinese Fonts
Aug 21, 2012mentioned database is created with Character set = UTF8 and the National Character Set = AL16UTF16 and got the result for other languages (latin,german,french etc) but still Chinese language was not supported.
NLS_CHARACTERSETAL32UTF8
NLS_NCHAR_CHARACTERSETAL16UTF16
I was getting the output as given below-
SQL> select translator ('table and chair','zh-CN','en') English_to_chinese from dual ;
ENGLISH_TO_chinese
--------------------------------------------------------------------------------
┐┐┐┐┐
and the function is given below
/* Formatted on 16/08/2012 21:55:39 (QP5 v5.215.12089.38647) */
CREATE OR REPLACE FUNCTION translator (p_words IN CLOB, -- words to be translated
p_to IN VARCHAR2, -- language to translate to
[Code].....
Installation :: Does Windows 7 Home Basic Support Oracle 11g
Jun 7, 2012Does windows 7 home basic support oracle 11g?
i am getting some error during installation.
SQL Server Query - Oracle Does Not Support OUTER APPLY Statement
Feb 1, 2012DECLARE @MainTable TABLE (UniqueID INTEGER, Category VARCHAR(200), WeekDate DATETIME, VALUE INTEGER)
INSERT INTO @MainTable VALUES(123, 'Shirts', '10/07/2011', 5000)
INSERT INTO @MainTable VALUES(123, 'Shirts', '10/14/2011', 8000)
INSERT INTO @MainTable VALUES(124, 'Pants', '10/07/2011', 4000)
INSERT INTO @MainTable VALUES(125, 'Shorts', '10/14/2011', 8000)
INSERT INTO @MainTable VALUES(126, 'Shoes', '10/21/2011', 9000);
--select * from @MainTable;
[code]...
The query works with all the CTEs up to the last select statement. Oracle does not support the OUTER APPLY statement, how should the last piece be written to make it work in Oracle?
SQL & PL/SQL :: Structure Schemas Within Single Oracle Instance To Support Multiple Project Development
Jan 24, 2013The best way to structure my schemas within a single Oracle instance to support multiple project development. At the moment, within an Oracle instance I have Area_Dev and Area1_Test schemas, with the intention that Project Xv1.0 would use Dev schema for development and Test schema for testing.
Lets say I want to start on Project Xv2.0 development while I am still finalizing Project Xv.10 development what is the best way of accommodating that, without creating individual schemas for each project?
Server Utilities :: Does Oracle Forms / Report Services (Standalone) Support Data Export Utility
Jun 10, 2010I have a From which take Logical Backup through oracle export utility. This Form work fine when i Start OCJ4 but when i want to take backup after running oracle Forms & Report services its not take backup.
My Question is dose Oracle Forms & Report Services (Standalone) Support data backup through Export (exp) utility. I have install Oracle Forms and Report Services (Standalone) on Window XP (SP-3).
Cloud Service :: How To Use Domain Name For APEX Application At Oracle Cloud
Feb 25, 20131. I have for example my-custom-domain.com and want that my customers use this domain to login at APEX Application at Oracle Cloud. I don't want that my customers see
[URL]........
and see instead of my-custom-domain.com :)
How I can do it? Don't find any technical information about it...
2. Can I use my ssl certificates for my domain for Oracle Cloud Instance?
External Table Concept
Jun 22, 2009Provide material for External table concept .which is like exactly as SQL * Loader concept.
What are the basic difference between External table concept and SQL * Loader concept.
Hierarchical Retrieval Concept
Oct 20, 2010Any links on hierarchical retrieval concepts?
View 3 Replies View RelatedDatabase Normalization Concept
Jun 24, 2013the database normalization concept. I have gone through couple of blogs and the websites but even i am not clear about the 1NF, 2NF, 3NF, Boycee Code etc, may be i am missing the basic points. give me some example notes / more clear precise information to understand the concepts clearly.
View 2 Replies View RelatedSQL & PL/SQL :: Normalization - Concept Of Primary Key / Composite Key
May 17, 2013I am following Lynda Tutorial for Normalization. I have understand normalization.The core concept of primary key is that it uniquely identifies each record in the table, but here in the given below image the 'COURSE' field is repeating 'SQL101' value again and again but still the teacher in the video is calling it primary key and combination of date & Course column Composite key.how can a field which vales are repeating can be called as Primary Key?
View 12 Replies View RelatedWhat Is Stripping Concept In Automatic Storage Management
Sep 21, 2012What is Stripping concept in Automatic Storage Management?
How it spreads the database files across the disk group (Suppose i am having 4 disks in my disk group)?
Data Guard :: Fast-start Failover Concept?
Jun 17, 2010what is the configuration dba has do for enabling the "fast-start failover concept" in the event of loss of primary database without requiring any manual steps to invoke the failover.whether the configuration are to be made in parameter file if yes what are those ?
View 1 Replies View RelatedServer Administration :: Query On Redo And Undo Basic Concept
Nov 17, 2010understanding a redo/undo concept . Refer following data
create table t(n number);
insert into t values(10);
commit;
now I update as following
update t set n=20;
As per my understanding the before image i.e. n=10 is stored in undo (to be used for rollback, transaction recovery and even in instance recover but not in media recovery) and after image n=20 is stored in redo (to be used for various recovery purposes including media recovery in case of consistent backup).
So it is redo logs for rolling forward and undo for rolling back making transaction, db consistent . If my above understanding is true then what is meant by the term 'redo required for undo'?
Also, if there are 2 database db1 and db2 connected using database link where we are populating t1 table in db1 using t2 table in db2 using db link where redo and undo will be updated db1 or db2?
Rebuilding A Domain Index
Apr 1, 2013I have a table in my application that has the following structure
Create table EVENT (project_id number, DISC_CMPLNT_TX clob, MAINT_ACT_TX CLOB,LGBK_CMT_TX VARCHAR2(1000 CHAR))
PARTITION BY RANGE (project_id)
(PARTITION pmax VALUES LESS THAN (MAXVALUE));
I have created the below preference on the three columns of the table.
begin
ctx_ddl.create_preference ('skipJoinLexer', 'BASIC_LEXER');
ctx_ddl.set_attribute ('skipJoinLexer', 'skipjoins', ';:.,()<>*"''#-');
ctx_ddl.create_preference ('logbookTextDS', 'MULTI_COLUMN_DATASTORE');
ctx_ddl.set_attribute ('logbookTextDS', 'COLUMNS', 'DISC_CMPLNT_TX, MAINT_ACT_TX,LGBK_CMT_TX');
end;
I have created a local partitioned index with the parameter NOPOPULATE create index lb_text_idx on ac_maint (DISC_CMPLNT_TX) indextype is ctxsys.context local parameters ('lexer skipJoinLexer datastore logbookTextDS NOPOPULATE');
When an new value of project_id is inserted into table1 , I create a partition using the following command where prjId is the new value of the project_id ALTER TABLE EVENT split PARTITION pmax AT ('||prjId||') INTO ( PARTITION p_' || prjId || ', PARTITION pmax)
Now I run a huge data load into the EVENT table for a project Id say 1 and insert millions of records.I want to rebuild the lb_text_idx for this partition alone so that data is available for searching by the application. I did a rebuild using the command " alter index lb_text_idx rebuild partition p_1".
However when I run the below sql, I get a count of 0. I know that the text MAINT is definitely present in the table.
SELECT COUNT(1) FROM EVENT WHERE PROJECT_ID = 1 and contains (DISC_CMPLNT_TX, 'MAINT' ) > 0
When I run the below sql select parameters,status from user_ind_partitions where partition_name = 'P_1' , I get parameters as null and status as usable.Am I getting 0 records because the parameters are set to null? How do I rebuild with the same parameters for the specific partition alone.