|
I have an ASP .NET application that connects to an Oracle or a SQL Server database. An installer has been developed to install a fresh database to an existing SQL Server using sql commands such as "restore database..." which simply restores a ".bak" file...
Started by Carl on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
More recently (2007), I scripted the creation of an Oracle 10g database that I was originally hired to lead its conversion from a SQL Server database to an Oracle databaseThe question is -- what do your....
Stuff instead).
|
|
I have one ee 10g and 30 se-1 mv sites ,i have to replicate more than 100 tables from aabout 30 sites which have standared edition one to master site(enterprise edition0 .
1. Is it possible if yes then how?
2. is it will be 2 way updatable changes on ...
Started by DBA-009 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at oracle):
Are the same structure but obviously data are different i need to replicate each site to master site (10g for your reply yes the database structure is the same for all the sites means all the tables EE) infact updatable MVs worked....
|
|
On Wed, 15 Apr 2009 23:50:35 -0700 (PDT), Veeru71 <m_adavi@hotmail.com
We need to replicate (1-way) a bunch of tables from Server-A to
Server-B in close to real-time.
Server-B is located in a foreign country.
Apporx. # of tables to be replicated...
Started by Veeru71 on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
We used it ....
If the requirement is "near-real-time", the question is how near to
real-time does it need to be? seconds? minutes? hours?
Once the tables are duplicated, you need to worry about how much data
per second, personally.
|
Ask your Facebook Friends
|
On Sat, 18 Apr 2009 10:53:27 -0500, "Bob Jones" <email@me.not
"Veeru71" <m_adavi@hotmail.comnews:1b53dd4e-96fa-452f-b7bd-1f49c87a255d@v23g2000pro.googlegroups.com...
Basic replication is the easiest solution. Just have everything set up on ...
Started by Bob Jones on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
You
also have....
I've done will be a problem.
The change log is
deleted once all the changes are committed .
In such cases, the changes should some how
get queued and applied the changes to database B.
With Server-
B or the network, etc.
|
|
On Sun, 19 Apr 2009 23:34:33 -0700 (PDT), Murty <m_adavi@hotmail.com
Thanks for you all your responses....Here are some more details.
1) Near real-time <--
2) Server A can have DB Link to Server B (But the other way is
prohibited)
3) We ...
Started by Murty on
, 10 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Then again, all you're doing is reinventing fast-refresh to A? The DB link owner can have ... .
The change log is
deleted once of the batch process on your A database.
Minutes, reading the
changed rows and pushing the changes to database B.
|
|
Hello All,
we are using EMC recoverpoint to replicate to the DR.it's a 10g RAC(windows2008R2) setup.we are replicating 2 volumes-RAW (ASM) 600GB and OCFS(100GB) to the DR.The replication is in sync and we tried to
test the volumes in DR. Both the disks...
Started by user4487322 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at oracle):
Would like to know how can we present the ocfs disk to oracle..
I will loose my data
replicated from primary site.
|
|
How to design a database that supports a feature that would allow the application user to create a snapshot of their data at a point in time, a bit like version control.
It would give the user the ability to go back and see what their data looked like...
Started by saille on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
SQL Server 2005 (onwards) Enterprise Edition has the ability to create Database snapshots
Oracle from version 9i have Flashback technology, which is in Oracle 10g and 11g much improved and you can then "play-back" those logs....
|
|
We have a third-party that feeds data to us. Their client application feeds directly to some source tables in our Oracle 10g database. We have triggers on these tables that sort and process the rows as they come in.
We have a new operation and we're trying...
Started by blarman74 on
, 8 posts
by 3 people.
Answer Snippets (Read the full thread at oracle):
The trigger has to do a lot, so/updated/deleted....
I'm using 10g.
HSODBC or DG4ODBC then the only way to replicate the data from the Oracle database to the SQL Server access to a downstream system to view it in Oracle.
|
|
Hi,
I am using Oracle 10.2.0.4.
I have the following XML:
with sd as (select xmltype( '<Fruits> <Fruit> <FruitType>Apple</FruitType> <FruitSubtype>Granny Smith</FruitSubtype> </Fruit> <Fruit> <FruitType...
Started by Boneist on
, 13 posts
by 3 people.
Answer Snippets (Read the full thread at oracle):
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production PL/SQL Release 11.2.0.3.0 (which I know how to do) and then do a group by on the XMLTABLE resuilts? Indeed, that's a possible way code?
Also, is there a handy....
|
|
Hello,
I cloned an Oracle databse 9.2.0.6 from production to test. We had cloned the database in the past using the same procedure without any problem. However, this time it gave us problem in form 6i and form 10g.
When execute procedure DBMS_SESSION....
Started by user8175606 on
, 9 posts
by 3 people.
Answer Snippets (Read the full thread at oracle):
This is a bug in ....
How could this be, this is a clone database? My feeling is we.
I posted this question to oracle support but after waiting for 5 days, they said the database version to point to character set conversion.
|
