Home » SQL & PL/SQL » SQL & PL/SQL » queries on oracle
queries on oracle [message #2019] Mon, 17 June 2002 07:54 Go to next message
Mallik
Messages: 5
Registered: April 2002
Junior Member
1.i want to backup all mydata automatically. and
also i want to backup the data for every hour.
give detail description with step by step.
2.i want to connect remote server database for that
what i have to do.
3.how can we insert the data through nested table(runtime)
Re: queries on oracle [message #2026 is a reply to message #2019] Mon, 17 June 2002 21:38 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member

SIR,

1.IF YOU WANT TO TAKE AUTOMATIC BACKUP,THEN YOU SHOULD USE THE RMAN UTILITY.I.E REMOTE DATABASE WILL TAKE YOUR CURRENT DATABASE BACKUP.IT HAS A LOT OF ADVANTAGES THAN MANUAL BACKUP.STUDY THE MANNUAL AND TR IT.IF YOU HAVE ANY DOUBT ON THIS, I WILL HELP YOU OR YOU CAN CONTACT ONE MAN IN US (balagib2@hotmail.com).he is very good in rman utility.

2.FOR THE SECOND PROBLEM

i read your message.no problem .it is quite
easy.
i am giving one example for you.

for example take the first database
(
sid=orcl
database name=oracle
db_domain=uk.com
host string=ss1
)

first edit the parameter file for the following

db_domain=uk.com

then start the database

In the svrmgr30.exe or sqldba execute this command

alter database rename global_name orcl.uk.com;

(name should be sid.db_domain)
then you execute this command

select * from global_name;

then you got the global database name for that
database like

orcl.uk.com

then go to the second database

(sid=tan
databasename=tani
db_domain=usa.com
host string=ss2
)

edit the parameter file for that database
db_domain=usa.com

start the database

execute this command in the svrmgr30 or sqldba

alter database rename global_name tan.usa.com;

(if in this server also the sid is orcl
don't worry.but only thing is
you should have different
db_domain parameter in each database)

execute this query

select * from global_name;

tan.usa.com

go to the first database

then create the database link by following

(execute this command in the first database)

create database link tan.usa.com
conect to system identified by manager
using 'ss2';

note :

the database link name should be the global database
name for the another database

if you have any problem ,please mail to me.

regards
k.sreenivasan
Previous Topic: i know there'll be only one record
Next Topic: Stored Procedure problem
Goto Forum:
  


Current Time: Mon Oct 22 17:35:34 CDT 2018