dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Make Oracle AR applications working read-only - Database Discussions

This is a discussion on Make Oracle AR applications working read-only - Database Discussions ; Yong Huang wrote: > "SW" wrote in message news: ... > ... > > 2. Make the related tablespaces read-only > > Can you try that? I think it should work. There's a FND_ table that > lists tablespaces for ...


Home > Database Forum > Database and Unix Discussions > Database Discussions > Make Oracle AR applications working read-only

Reply

 

LinkBack Thread Tools Display Modes
  #71  
Old 12-01-2004, 11:40 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Make Oracle AR applications working read-only


Yong Huang wrote:
> "SW" wrote in message

news:<1101606986.723875.293260@z14g2000cwz.googlegroups. com>...
> ...
> > 2. Make the related tablespaces read-only

>
> Can you try that? I think it should work. There's a FND_ table that
> lists tablespaces for each product. I think it's
> FND_PRODUCT_INSTALLATIONS. Just make the tablespaces for the AR
> product read-only.
>
> Yong Huang


Basically, there are 3 data tablespaces related to Oracle AR. They are
FND, AR & SHR. To make Oracle AR still operational, we must remain FND
read write which includes all the Oracle AR system tables inside. We
can only make AR & SHR read only since they contain all the customer
data which we don't want to change during the migration period. Thanks
a lot again!

Reply With Quote
  #72  
Old 12-01-2004, 11:40 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Make Oracle AR applications working read-only


Yong Huang wrote:
> "SW" wrote in message

news:<1101606986.723875.293260@z14g2000cwz.googlegroups. com>...
> ...
> > 2. Make the related tablespaces read-only

>
> Can you try that? I think it should work. There's a FND_ table that
> lists tablespaces for each product. I think it's
> FND_PRODUCT_INSTALLATIONS. Just make the tablespaces for the AR
> product read-only.
>
> Yong Huang


Basically, there are 3 data tablespaces related to Oracle AR. They are
FND, AR & SHR. To make Oracle AR still operational, we must remain FND
read write which includes all the Oracle AR system tables inside. We
can only make AR & SHR read only since they contain all the customer
data which we don't want to change during the migration period. Thanks
a lot again!

Reply With Quote
  #73  
Old 12-01-2004, 11:40 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Make Oracle AR applications working read-only


Yong Huang wrote:
> "SW" wrote in message

news:<1101606986.723875.293260@z14g2000cwz.googlegroups. com>...
> ...
> > 2. Make the related tablespaces read-only

>
> Can you try that? I think it should work. There's a FND_ table that
> lists tablespaces for each product. I think it's
> FND_PRODUCT_INSTALLATIONS. Just make the tablespaces for the AR
> product read-only.
>
> Yong Huang


Basically, there are 3 data tablespaces related to Oracle AR. They are
FND, AR & SHR. To make Oracle AR still operational, we must remain FND
read write which includes all the Oracle AR system tables inside. We
can only make AR & SHR read only since they contain all the customer
data which we don't want to change during the migration period. Thanks
a lot again!

Reply With Quote
  #74  
Old 12-01-2004, 01:33 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Seeking DBA Senior Oracle Expert/PL/SQL


We require highly experienced Oracle Database Administrators with extensive knowledge in programming Oracle working on either versions 8 or Oracle 9i. Tasks consist of programming and writing specification scripts on PL/SQL, planning, documentation, from Conception, including optimization and selection of software tools. The ideal candidates selected will be working in a senior capacity with scope of moving into management.

Locations: Prague and Germany.

Please forward your applications to: Gina Gates at Gina.gates@p-45.com, or if you have a friend or colleague who you believe will be suited to these positions please ask them to forward their resume ASAP to have an interview arranged

--
Message posted via http://www.oraclemonster.com
Reply With Quote
  #75  
Old 12-01-2004, 01:33 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Seeking DBA Senior Oracle Expert/PL/SQL


We require highly experienced Oracle Database Administrators with extensive knowledge in programming Oracle working on either versions 8 or Oracle 9i. Tasks consist of programming and writing specification scripts on PL/SQL, planning, documentation, from Conception, including optimization and selection of software tools. The ideal candidates selected will be working in a senior capacity with scope of moving into management.

Locations: Prague and Germany.

Please forward your applications to: Gina Gates at Gina.gates@p-45.com, or if you have a friend or colleague who you believe will be suited to these positions please ask them to forward their resume ASAP to have an interview arranged

--
Message posted via http://www.oraclemonster.com
Reply With Quote
  #76  
Old 12-01-2004, 01:33 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Seeking DBA Senior Oracle Expert/PL/SQL


We require highly experienced Oracle Database Administrators with extensive knowledge in programming Oracle working on either versions 8 or Oracle 9i. Tasks consist of programming and writing specification scripts on PL/SQL, planning, documentation, from Conception, including optimization and selection of software tools. The ideal candidates selected will be working in a senior capacity with scope of moving into management.

Locations: Prague and Germany.

Please forward your applications to: Gina Gates at Gina.gates@p-45.com, or if you have a friend or colleague who you believe will be suited to these positions please ask them to forward their resume ASAP to have an interview arranged

--
Message posted via http://www.oraclemonster.com
Reply With Quote
  #77  
Old 12-01-2004, 01:33 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Seeking DBA Senior Oracle Expert/PL/SQL


We require highly experienced Oracle Database Administrators with extensive knowledge in programming Oracle working on either versions 8 or Oracle 9i. Tasks consist of programming and writing specification scripts on PL/SQL, planning, documentation, from Conception, including optimization and selection of software tools. The ideal candidates selected will be working in a senior capacity with scope of moving into management.

Locations: Prague and Germany.

Please forward your applications to: Gina Gates at Gina.gates@p-45.com, or if you have a friend or colleague who you believe will be suited to these positions please ask them to forward their resume ASAP to have an interview arranged

--
Message posted via http://www.oraclemonster.com
Reply With Quote
  #78  
Old 12-01-2004, 01:33 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Seeking DBA Senior Oracle Expert/PL/SQL


We require highly experienced Oracle Database Administrators with extensive knowledge in programming Oracle working on either versions 8 or Oracle 9i. Tasks consist of programming and writing specification scripts on PL/SQL, planning, documentation, from Conception, including optimization and selection of software tools. The ideal candidates selected will be working in a senior capacity with scope of moving into management.

Locations: Prague and Germany.

Please forward your applications to: Gina Gates at Gina.gates@p-45.com, or if you have a friend or colleague who you believe will be suited to these positions please ask them to forward their resume ASAP to have an interview arranged

--
Message posted via http://www.oraclemonster.com
Reply With Quote
  #79  
Old 12-01-2004, 01:33 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Seeking DBA Senior Oracle Expert/PL/SQL


We require highly experienced Oracle Database Administrators with extensive knowledge in programming Oracle working on either versions 8 or Oracle 9i. Tasks consist of programming and writing specification scripts on PL/SQL, planning, documentation, from Conception, including optimization and selection of software tools. The ideal candidates selected will be working in a senior capacity with scope of moving into management.

Locations: Prague and Germany.

Please forward your applications to: Gina Gates at Gina.gates@p-45.com, or if you have a friend or colleague who you believe will be suited to these positions please ask them to forward their resume ASAP to have an interview arranged

--
Message posted via http://www.oraclemonster.com
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 12:33 PM.