Oracle Example Databases And Tables

Oct 3, 2011

I'm just wondering because i didn't find any example / test databases for Oracle. Thus MS has its "northwind", mysql its "world" or "sakila".

Additionally, the tables view is quiet confusing, referring to all those generated tables (

[URL]........

I tried right-click + apply filter *remove generated* but it didn't work.

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: Comparing Tables In Two Different Databases

Apr 13, 2011

As part of our project, we need to perform table comparisons in two different databases. I am currently looking for various options to accomplish this.

One of them is doing minus operation between these two tables. Also, i have looked at the data compare option in toad utility.

View 1 Replies View Related

SQL & PL/SQL :: Create Stored Procedure Where Tables Of Two Different Databases Are To Be Used?

Feb 22, 2012

I want to create a stored procedure where tables of two different databases are to be used.

View 4 Replies View Related

Backup & Recovery :: Migrating Databases / Task To Migrate Total Databases

Mar 27, 2012

I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.

steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt MKDIR 'c:oraclexeapp mp';

2 From SQL prompt conn system/kotak;

3 create or replace directory dmpdir as 'c:oraclexeapp mp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt conn system/kotak;

2 create or replace directory dmpdir as 'c:oraclexeapp mp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt set ORACLE_SID=xe;

5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING created 4 tablespaces

1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD

View 1 Replies View Related

SQL & PL/SQL :: How To Synch Two Oracle Databases

Aug 2, 2010

I have cloned the database into another using DBMS_METADTA API (export the metadata in xml form and recreate it on destination). I need to synch these two periodically. I need to update the XML to synchronize the databases.

I don't have 11g to use DBMS_METADATA_DIFF API.

View 7 Replies View Related

ShadowProtect To Backup Oracle Databases?

Mar 22, 2013

if you are using ShadowProtect to backup your Oracle databases. What are your experiences and the pros and cons in using ShadowProtect as the one and only backup/recovery tools for Oracle databases? Can the potential of ShadowProtect replaces the commonly use Oracle backup/recovery tools?

The reason why I raise this question is because my boss has the idea that ShadowProtect is THE best backup/recovery tools. Personally I don't think so, because there can be cases where we only need to recover the database and not the whole OS.

View 6 Replies View Related

Migrate MySQL And Access Databases Over To Oracle 9i

Oct 2, 2008

I need to migrate MySQL and Access databases over to Oracle 9i. Is there a tool that will do this and also migrate sql scripts?

I heard of Oracle Workbench as one tool I could use?

View 4 Replies View Related

Server Administration :: Migrate Two Different Databases To Oracle?

Jul 11, 2012

I have to migrate two different databases to oracle.i have made two Migration Repository for each to do the migration, migration is done.but i would like to know can it be done with one migration repository.if yes then with one is best way to do it.data of two databases is different but table and sp are 99% same.

View 3 Replies View Related

Bring Down The Databases In Oracle Fail Safe Environment?

Jun 28, 2013

How can we bring down the databases in oracle fail safe environment?

We have one database X in two server�s windows A & B with oracle fail safe environment.
What procedure should we fallow to bring down the database X.

Today I was strangling to bring down the database because database was automatically coming up once brought down the database. what procedure should we follow to bring down the database in OFS environment.

View 1 Replies View Related

SQL & PL/SQL :: Give Grant To Schema Of Different Versions Of Oracle Databases?

Aug 8, 2012

I have a task assigned to "grant select on sys.link$" to a user which exists on 500 different databases.

This needs to be done in Oracle database.

View 6 Replies View Related

List Exiting Databases In Oracle Server Using SQL Plus Command?

Feb 14, 2013

I am using Oracle database server and I want to show existing databases on that server. Are there any SQL plus command to list all databases there in the server?

View 1 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

How To Use Perl DBI Script To Poll Logs From Oracle Databases

Jul 27, 2010

I have 2 separate servers each with oracle database installed.I am trying to pull oracle logs from these 2 databases to my main linux server using perl DBI. On this linux server I have 1 dbipoll.pl script and 2 wrapper scripts that pass in parameters to dbipoll.pl.

Here is the sample wrapper script that I've used to call dbipoll.pl(separate script with different parameters for each databases used):

CODE#!/bin/sh
#
export ORACLE_HOME=/ora-main/app/oracle/product/11.1.0.6/db
export ORACLE_SID=rmdev1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME
#

[code]....

As you can see,the script should retrieve logs and write to oracledb1.log and update the countfile1 with the latest timestamp.The wrapper scripts are scheduled to run at 5mins interval.

The first wrapper script,which I've named as call_dbipoll1.sh runs fine. I am able to retrieve events and both oracledb1.log and countfile1 are successfully updated.

However,the second wrapper script,call_dbipoll2.sh is successful only for the first run. For subsequent runs,I've noticed that countfile2 does not get updated with the latest timestamp(ie. the file returns to blank) and oracledb2.log returns to blank as well. Therefore,am unable to pull new events then. Unable to determine what went wrong here..

Here is sample of my second wrapper script that tries to retrieve events from the 2nd database:

CODE#!/bin/sh
#
export ORACLE_HOME=/ora-main/app/oracle/product/11.1.0.6/db
export ORACLE_SID=rmdev2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME
#

[code]....

View 1 Replies View Related

Server Administration :: Create Two Databases With Different Sides On One Oracle Home?

Jun 8, 2010

i want to create two databases with different sids on one oracle home.

how can ı handle it?

View 2 Replies View Related

Replication :: To Upgrade All Oracle 10g Master Sites / Databases To 11g Release

May 28, 2009

I want to upgrade all the Oracle 10g Release (10.2.0)master sites (bi-directional) databases to Oracle 11g Release (latest). In fact, we are using bi-directional oracle streams and snapshot replication, it means capture,propagate and apply process is running.

View 1 Replies View Related

Calculate Total Disk Space Used By Oracle Databases Across Whole Company?

Oct 18, 2013

If we want to know the number of instances, number of RAC databases  and whole total disk space used by oracle (not file system size),1. Any script can be ran from OEM grid control against all instances/databases? or2. we have a repository unix server which has all tnsnames of whole databases, any script we can run from there?

View 5 Replies View Related

Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases

Mar 5, 2013

what type of storage systems used for saving archive files and backup files "especially for oracle databases"

View 5 Replies View Related

Install Multiple Versions Of Oracle Databases 10GR2 And 11GR2 In A Single Node?

Oct 28, 2010

ORACLE DBA
EXPERTS

�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?

View 6 Replies View Related

Implementation Where Data From DB2 Tables Are Moved To Oracle Tables

Sep 3, 2012

I came across an implementation where data from DB2 tables are moved to Oracle tables, for BI solutioning, using some oracle procedures called from MS SQL DTS packages which are scheduled jobs.Just being curious, can this be done using OWB or ODI rather than the above detour. I suppose there are some changes being done in those procedures before the data is being loaded into Oracle tables, can't this be done using OWB/ODI? Can it be scheduled too as jobs using OWB/ODI?

View 1 Replies View Related

Server Administration :: How To Install Oracle 8i And 9i Databases On Same Server

Feb 20, 2011

How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.

View 7 Replies View Related

Can Monitor 10.2.0.2 Databases Using OEM 11g

Feb 7, 2011

In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.

Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?

View 2 Replies View Related

Same Server Two Databases

Oct 3, 2012

I have a windows 2008 server.

I already installled oracle software for oracle_home C:/oracle/product/11.2.0/dbhome_1 for database DEV.

Now, I want to create new database with different oracle_home on same server with oracle_home as C:/oracle/product/11.2.0/dbhome_2 and SID as TEST.

Do I have to istall oracle software again ? if yes, what about inventoryfiles in C:\Program Files\Oracle\Inventory ? wont they be overwritten ?

View 3 Replies View Related

Multiple Databases With Same Name?

Nov 23, 2010

We are getting a consultant to upgrade an Oracle 9i installation to 11g R2. The current installation has 6 different databases installed on the same server. Each database is a different customer so for reasons of security we have requested that this be split into 6 virtual machines with one database per machine.

The consultant suggested that they could install the 11g database once and then just make copies (which would all have the same instance name. We are told that the TNS names can be configured so clients are directed to the right database.

View 3 Replies View Related

SQL & PL/SQL :: Sequence Can Be Used Across Databases?

Mar 19, 2012

As we can give grant on sequence and can use in different schema of same database, can same sequence be used across databases?

View 2 Replies View Related

Drop All Tables In Oracle 8

Dec 17, 2012

i want drop all tables in oracle8

View 2 Replies View Related

Replication :: Oracle Tables From 10.2.0.4 To 9.2.0.6?

Nov 19, 2009

Are there any recommendations to replicate oracle tables from 10.2.0.4 to 9.2.0.6 ?

I am new to oracle, thinking about streams and material views. And not sure which option should we choose ?

Any pros and cons (especially related to the versions). Can I use streams to replicate 10.2.0.4 to 9.2.0.6 ?

View 3 Replies View Related

SQL & PL/SQL :: Oracle Join On Tables

Sep 11, 2013

CREATE TABLE MTCH_TBL
(
S_PAID VARCHAR2(100),
S_SEC NUMBER,
H_PAID VARCHAR2(100),
H_SEC NUMBER
);
[code]....

My requirement is to match the records in MTCH_TBL and HIST_TBL on the basis of joining S_SEC(MTCH_TBL) with SEC_ALIAS(HIST_TBL) and INSTANCE (HIST_TBL) as 100 and choosing the record with max EFF_DATE from HIST_TBL.

I have come up with a query as:

select a.h_sec, a.s_paid, a.h_paid
FROM MTCH_TBL a,
HIST_TBL b
where a.S_SEC=b.sec_alias(+)
and b.instance(+)=100
and b.EFF_DATE =
[code]...

join using the EFF_DATE field also and get the expected results.My results are appearing as BLANK. However I need to produce the results as stated below:

Now, i need the results as:

H_SEC= 526
S_PAID= Q00
H_PAID = Q00

View 39 Replies View Related

SQL & PL/SQL :: How To Add Oracle Constraint To Tables

Jan 4, 2013

I have three tables:

A {op_id, op_name, .}
B {b_id, op_id, supplier_id, .}
C {c_id, op_id, op_id2, supplier_id, relation, .}

Table B and C have op_id which is foreign key from table A. In table A op_id is primary key, in table B b_id is primary key and in table C c_id is primary key. In table B supplier_id and op_id may have duplicate records. Now I want to add constraint so that if I delete records from Table B for op_id and if a relationship record exists for op_id in table C then it should not allow me to delete. Is it possible through referential integrity constraint ?

View 5 Replies View Related

SHOW TABLES In Oracle?

Mar 31, 2004

In MySQL, I can get a list of all tables w/ this query: "SHOW TABLES"

Whats the syntax w/ Oracle 9i ?

Looked through the docs online, but w/o knowing what you're trying to look up, you can't really look anything up (kind of a catch22).

View 9 Replies View Related

Copy Data Between Databases

Oct 12, 2012

I want copy some tables from one database to another. Which of following is the fastest way:

- INSERT /*+APPEND*/ via database link
- Transportable Tablespaces
- datapump IMP/EXP (I supposed it's the slowest way)

View 2 Replies View Related







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