peru_edaite_enti Posted April 22, 2013 Report Posted April 22, 2013 [quote name='STFU' timestamp='1366662710' post='1303646976'] production lo ki move chestunaru aduke inka em ayina sources unnai ani seraching [/quote] naku aite no idea to move.. oracle to oka sr open chesi chudu.. vallu em antaro
KOTC Posted April 22, 2013 Author Report Posted April 22, 2013 [quote name='CBZ' timestamp='1366662875' post='1303646996'] naku aite no idea to move.. oracle to oka sr open chesi chudu.. vallu em antaro [/quote] 10.1 ki no support anukunta bhayya.yeah ade pani unnaru ma valu.
CheGuevara Posted April 22, 2013 Report Posted April 22, 2013 [quote name='STFU' timestamp='1366663088' post='1303647018'] 10.1 ki no support anukunta bhayya.yeah ade pani unnaru ma valu. [/quote] no need of oracle.............streams use chey it will work...chala easy streams.... 10g source and 11g target aite you can use streams for one way replication
KOTC Posted April 22, 2013 Author Report Posted April 22, 2013 [quote name='CheGuevara' timestamp='1366663723' post='1303647091'] no need of oracle.............streams use chey it will work...chala easy streams.... 10g source and 11g target aite you can use streams for one way replication [/quote] avuna will search on it.nuv chesava eppudu ayina?
CheGuevara Posted April 22, 2013 Report Posted April 22, 2013 [quote name='STFU' timestamp='1366664021' post='1303647122'] avuna will search on it.nuv chesava eppudu ayina? [/quote] nope...but its compatible if its one way replication from 10g to 11g but not vice-versa
KOTC Posted April 22, 2013 Author Report Posted April 22, 2013 [quote name='CheGuevara' timestamp='1366664575' post='1303647175'] nope...but its compatible if its one way replication from 10g to 11g but not vice-versa [/quote] avuna ok dani search chesta aithe
Gachibowli_Diwakar Posted April 23, 2013 Report Posted April 23, 2013 [quote name='CheGuevara' timestamp='1366663723' post='1303647091'] no need of oracle.............streams use chey it will work...chala easy streams.... 10g source and 11g target aite you can use streams for one way replication [/quote] streams aina golden gate aina .. replication set cheyali ante initial ga data-load cheyali .. even for that he has to use either expdp or exp or transportable tablespace
CheGuevara Posted April 23, 2013 Report Posted April 23, 2013 [quote name='Silence..Please' timestamp='1366682488' post='1303648701'] streams aina golden gate aina .. replication set cheyali ante initial ga data-load cheyali .. even for that he has to use either expdp or exp or transportable tablespace [/quote] data load enti...akakda already data undata 10g lo danni 11g lo replicate cheyyali ....nuvvu annadi naakua rdam kaledu...konchem explain chey
peru_edaite_enti Posted April 23, 2013 Report Posted April 23, 2013 [quote name='CheGuevara' timestamp='1366683142' post='1303648730'] data load enti...akakda already data undata 10g lo danni 11g lo replicate cheyyali ....nuvvu annadi naakua rdam kaledu...konchem explain chey [/quote] agreed... kusanta vivarimpumu
KOTC Posted April 23, 2013 Author Report Posted April 23, 2013 http://www.devart.com/dbforge/oracle/schemacompare/new-export-oracle-schema.html
CheGuevara Posted April 23, 2013 Report Posted April 23, 2013 [quote name='STFU' timestamp='1366751485' post='1303652525'] [url="http://www.devart.com/dbforge/oracle/schemacompare/new-export-oracle-schema.html"]http://www.devart.co...cle-schema.html[/url] [/quote] e functionality antha sql devloper, toad lo undi kada....dini speciality enti???
peru_edaite_enti Posted April 23, 2013 Report Posted April 23, 2013 [quote name='STFU' timestamp='1366751485' post='1303652525'] [url="http://www.devart.com/dbforge/oracle/schemacompare/new-export-oracle-schema.html"]http://www.devart.co...cle-schema.html[/url] [/quote] JUST DDL aite a vere tool enduku bhayya, datapump lo contents=metadata only ani pedite saripoddi ga
KOTC Posted April 23, 2013 Author Report Posted April 23, 2013 [quote name='CheGuevara' timestamp='1366751657' post='1303652544'] e functionality antha sql devloper, toad lo undi kada....dini speciality enti??? [/quote] yeah toad lo undi e functionality,orike post chesa melo evaru ayina e tool use chestara ani?
KOTC Posted April 23, 2013 Author Report Posted April 23, 2013 [quote name='CBZ' timestamp='1366751798' post='1303652558'] JUST DDL aite a vere tool enduku bhayya, datapump lo contents=metadata only ani pedite saripoddi ga [/quote] DDL ki datapump enduku bhayya sql lo kuda cheyachu [background=transparent]sqlplus[/background][background=transparent]<<[/background][background=transparent]EOF [/background][color=#00008B][background=transparent]set[/background][/color][background=transparent] long [/background][color=#800000][background=transparent]100000[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]set[/background][/color][background=transparent] head [/background][color=#00008B][background=transparent]off[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]set[/background][/color][background=transparent] echo [/background][color=#00008B][background=transparent]off[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]set[/background][/color][background=transparent] pagesize [/background][color=#800000][background=transparent]0[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]set[/background][/color][background=transparent] verify [/background][color=#00008B][background=transparent]off[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]set[/background][/color][background=transparent] feedback [/background][color=#00008B][background=transparent]off[/background][/color][background=transparent] spool [/background][color=#00008B][background=transparent]schema[/background][/color][background=transparent].[/background][background=transparent]out [/background][color=#00008B][background=transparent]SELECT[/background][/color][background=transparent] DBMS_METADATA[/background][background=transparent].[/background][background=transparent]GET_DDL[/background][background=transparent]([/background][background=transparent]object_type[/background][background=transparent],[/background][background=transparent] object_name[/background][background=transparent],[/background][background=transparent] owner[/background][background=transparent])[/background][background=transparent] [/background][color=#00008B][background=transparent]FROM[/background][/color][background=transparent] all_OBJECTS [/background][color=#00008B][background=transparent]WHERE[/background][/color][background=transparent] [/background][background=transparent]([/background][background=transparent]OWNER [/background][background=transparent]=[/background][background=transparent] [/background][color=#800000][background=transparent]'OWNER1'[/background][/color][background=transparent]);[/background][background=transparent] spool [/background][color=#00008B][background=transparent]off[/background][/color][background=transparent] quit EOF cat [/background][color=#00008B][background=transparent]schema[/background][/color][background=transparent].[/background][background=transparent]out[/background][background=transparent]|[/background][background=transparent]sed [/background][color=#800000][background=transparent]'s/OWNER1/MYOWNER/g'[/background][/color][background=transparent]>[/background][color=#00008B][background=transparent]schema[/background][/color][background=transparent].[/background][background=transparent]out[/background][background=transparent].[/background][background=transparent]change[/background][background=transparent].[/background][background=transparent]sql[/background]
Recommended Posts