ERPstuff - Oracle EBS Community

Hi there SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Oracle does not supply any data unload utilities. However, you can use SQL*Plus to select and format your data and then spool it to a file: set echo off newpage 0 space 0 pagesize 0 feed o...

Hi there I assume you are talking about Veritas Netbackp that's partner of Oracle Backup Solutions Program (BSP). If you already integrated your RMAN with it then you don't need to take cold backups (check Veritas documentation for how to integrate Oracle database with it). However if you are taking...

Hi

You forgot to mention about which OS/Rel/SP you are talking about? Please be specific, all platform even releases may have different methods to project actual memory usage.

Thanks
Amir

I would say your answer is hidden in Oracle Text search i.e standard CTX_DDL. If you have different types of columns (CLOB,BLOB etc) that may contain PDF, RTF Documents etc then you should consider using Oracle Ultra search capabilities.

Thanks
Amir

Hi

You can use Formula Columns or can create a view that can be used as source in report.

Thanks
Amir

Hi there, You need to perform PIT (point in time) Recovery. As long as you provide your correct archive log files required by database you'll be able to recover as much as data. That's called roll forward and once you are finished with all of your archive log files it'll perform rollback of all unco...

Hi As I understand you are asking about how to run some "C" language program (your file name ending with .c) you can put it in shell script and then run as a scheduled job. Either you can create schedule file through Cron tab manager or can create it manually as well with specifiction of t...

Hi there Database is a collection of data that can be accessed through different methods/models. Like network, relational model etc. An Oracle database system comprises at least one instance of the application, along with data storage. An instance comprises a set of operating-system processes and me...

Hi Can you please elaborate what type of setup you have, which product version you are using? If you have two tier setup. There are possibilities to intercept at the application level i.e mid tier by number of application instances or sessions per client through sso/http server. The other way is at ...

Hi Before posting any topic always put your question in forum search engine. here is a thread for oracle vista client database download. http://www.erpstuff.com/forums/topic.asp?TOPIC_ID=1244 For previous database release change "compatibility" parameter accordingly it's working fine with ...

Hi there

can you tnsping to both server databases? if no check your local tnsnames.ora has the entry for both databases. TOAD is using local tnsnames. you can copy tnsnames.ora from other server where both databases are accessible.

Thanks

Hi

Can you please elaborate your question. Are you trying to apply logs from primary database to standby database? or it's a raplication issue.

Thanks

It's a some how cross table transformation. I would use decode() function to get desired result.

Thanks
Amir

Some how it depends on your STDBY DB configuration. If log shipping is optional then it doesn't matter if you bounce back your Primary database. But if you specified as mandatory then it's a different scenario. You need to make sure that last log has been shipped on the STDBY site then you can shutd...

Can you put any error appear when user try to sign-in after you change reponsibility. As I understand you said after 24hrs user is able to get in. Do you bounce-back servers at night? so actually user is o.k after application server tier gets restarted or metadata repository database gets restarted ...