New answers tagged

1

What about remote database side, what does it have to do? There must have Oracle Net installed on both local and remote database servers. And the user being used should have CREATE SESSION system privilege on the remote database. On fixed user link, local database need to know ID and password set. Is the ID is a usual account with which someone can ...


-4

Foreign key it is a relationship between the two tables,Primary key is a not allow the duplicates and nulls.


2

A fast refresh would copy incremental changes over the network but requires that a materialized view log be created on the master site on the source table. That adds some overhead to the inserts happening on the master table but would generally make the refresh more efficient. A complete refresh would copy every row over the network every time the ...


0

Grants and Revokes of Privileges to and from the PUBLIC Role You can grant and revoke privileges and roles from the role PUBLIC. Because PUBLIC is accessible to every database user, all privileges and roles granted to PUBLIC are accessible to every database user. By default, PUBLIC does not have privileges granted to it. Security ...


0

My guess select ID, valid_from , lead(valid_from,1,'31.12.2999') over (partition by id order by valid_from) as valid_to , case Item_a when '-' then lag(Item_a,1,'-') over (partition by id order by valid_from) else Item_a end as Item_a from t


0

export ORACLE_SID=test export ORACLE_HOME=/u01/oracle/product/10.2.0/db_1/ vi $ORACLE_HOME/dbs/inittest.ora control_files = (/u01/testcontrol1.ctl,/u01/testcontrol2.ctl,/u01/testcontrol3.ctl) undo_management = AUTO undo_tablespace = UNDOTBS1 db_name = test db_block_size = 8192 sga_max_size = 440401920 sga_target = 440401920 $ORACLE_HOME/bin/orapwd file=...


0

Tablespaces with different block sizes than the database exists because of transportable tablespaces, where you want to move the tablespace to a different database that has a different block size than the database you are moving the tablespace from (usually from an OLTP database to a data warehouse). Although certain sites claim you can get a performance ...


0

Yes. First you need a parameter file (init.ora). The only mandatory parameter is db_name to have a fully working database. Steps 1 - Create the parameter file: [myhostname@oracle $] vi $ORACLE_HOME/dbs/initorcl.ora db_name='orcl' :wq 2 - Export ORACLE_SID to reflect the db_name you which to create: [myhostname@oracle $] export ORACLE_SID=orcl 3 - ...


1

Yes, databases can be created without using DBCA from command line. 1) you need to export required environment variables 2) Create a parameter file (init$sid.ora) under $ORACLE_HOME/dbs substitute $sid with your instance name. 3) Create a SQL script for database creation 4) Connect to sqlplus, put the instance in no mount state and run the script to ...


0

In simple words, Instance is created first. Because when you create database manually, you start the instance first in no mount state and run the script for creating database. Another point to support my answer, access to Oracle database or creation of it is impossible without an instance.


3

Introduction to the Oracle Database Instance A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created by the CREATE DATABASE statement. The instance manages its associated data and serves the users of the database. Every running Oracle database is associated with at ...


0

Instance can not be created, it can "only" be started. Instance is something which is running. oradim is something Windows specific. It creates a record in Windows SERVICE registry, to start the instance during the boot. So in fact oradim does not create an instance, it creates a Windows service associated with the database (instance).


0

If you created the table with the above statement as user MDR_139, then that table belongs to the MDR_139 schema, not TESTSCHEMA. If you want to create tables in other schemas, add the schema specifier to the create statement, for example: create table TESTSCHEMA.sales_test (year number(4), product varchar2(10), amt ...


2

db_block_size is the default block size of the database, but it does not necessarily mean all your tablespaces have the same block size, you can have tablespaces with different block sizes. You need to define seperate cache areas for tablespaces with non-default block size. For example, if your db_block_size is 8192, and you want to create a tablespace with ...


0

The solution turned out to be to adjust the timezone on the DB server, clients and the entire cluster to UTC+1 (Europe/Oslo). This is the same as the cluster that has run for years without problems. However, I'm not completely sure why the "+1" does not cause the same problems as the "+3" in MSK.


4

The answer is right there, in the data. (I assume that the time part is 00:00:00 in all of them): The order by has ties. There is not one "first row" but 3 of them. So, when the 2nd query restricts the result to one row, one of the 3 is - arbitrarily - chosen. It may not be the same row chosen the next time you run the same query!


0

Community Wiki answer containing the solution given by Justin Cave in a question comment execute immediate takes a string. The snippet you posted has no strings in it. You'd need to assemble the appropriate string and then pass that to execute immediate. Something like: execute immediate 'alter table ' || var_table_name || ' rename ' || var_col ||...


0

I think this might be the kind of thing you need. WITH get_detail AS (SELECT get_addr(col1) AS obj_type from my_test) SELECT x.obj_type.district_name FROM get_detail x / This is what I created to test it out. CREATE OR REPLACE TYPE my_ADDRESS_DETAIL_T AS OBJECT ( apt_number NUMBER, district_name NVARCHAR2(40), zipcode NUMBER ) /...


0

This: EXECUTE IMMEDIATE ('ALTER SESSION SET CURRENT_SCHEMA =B') Does not do what you think it does. ;) That statement does not change who YOU are. It changes your default Schema for purposes of searching/finding an object. For example, try this: 1) Create a table in User TESTUSERB. Let's call it TEST 2) Login as User TESTUSERA. 3) desc TEST (...


0

I came to know from Oracle, inserting a sequence is possible with inserting the same sequence at the source as well, called cyclic sequence. For more details check the MOS doc "Implementing replication of cyclic sequences in GoldenGate (Doc ID 1321558.1)".



Top 50 recent answers are included