ERPstuff - Oracle EBS Community

http://www.oracle.com/technology/products/oracle9i/daily/apr04.html Materialized views, known as snapshots in prior releases, are used to replicate data to non-master sites in a replication environment. Updatable materialized views enable users to maintain data at their local site (even a mobile us...

Hi there

u can check your any segment size in bytes with this query.

select bytes from user_segments where segment_name = '<table_name>';

Have fun.

Amir

I was talking about this bank.

http://www.habibbank.com

Thanks



[quote]Just talked to http://www.hmb.com.pk/default.htm but no gain as online only in Pakistan. thanks

<i><div align="right">Originally posted by admin

Hi there It's a suggestion, instead of using any exchange company why don't you guys open an account of HSBC, HB AGZurich or ICICI Bank in local branches of Pakistan or India. Their foriegn branches providing wire transfer services to other branches located in Pakistan or India, either free or with ...

Hi You need to use this format check in your server DNS entries. <computer_name>.<domain_name>.com If DNS is not been setup up yet you need configure it. Make sure you can ping to your above address without any error. In windows XP click right mouse on My Computer->Computer Name-> Change-> <yourcomp...

Hi

Better you go for SEARCH option provided by the forum before post any new topic. Anyway try post below that may solve your purpose, or look for others.

http://erpstuff.com/topic.asp?TOPIC_ID=373

Thanks
Amir

Hi DELETE is like removing bricks one by one from a structure. If any wrong brick is removed you can put it back in the structure. Rows are deleted 1 by 1 from table and stored in rollback segment for read consistancy. There are some overheads involved since if you decide to undo you can get them ba...

Hi

You can use external table. That link shows practical demo of that new feature of 10g.

http://www.orafaq.com/node/848

Thanks
Amir

Hi As long as you can ping to your DB server from client machine, you can copy TNSNAMES.ora file from other client machine connected to the same DB Server. Make sure you check following points. The search order is: 1. TNS_ADMIN (Check this variable may be pointing to other location) 2. The Global Co...

Hi

Instead of using Net Configuration Assistant for each instalation, you could have copied over same TNSNAMES.ora to all machines in $ORACLE_HOME/network/admin directory.

Have fun.

Thanks
Amir

Hi If you wanna use it for TEST environment that's O.K. However for PROD it's never recommended. There are some extra overheads need to be taken into account when running Servers on VM. All instructions are translated at VM level first then passed on to OS and finllay to the Hardware, reverse layers...

Hi If you are talkin about 11i. Then it's already been configured for 100 users what you need to do is just seperate DB Server Tier from other components. Anyways the good configuration for Apps Server could be consist of these combinations 1- DB Server (Includes Meta Data Repository) on Linux/Unix....

Hi Please double check your given info. There is no version exist of Apps Server 6<i>i</i>. It's supposed to be DS6<i>i</i> (Developmnet Suite). If you mean Application Server 10g then you can check these links for installation and configuration. http://www.oracle-base.com/articles/10g/OracleAS10gIn...

Hi This is the best and simplest link I found for DB installation on Linux x86. http://www.dbspecialists.com/presentations/oracle10glinux.html#complete Tip: You can use HCVE script to run Pre-Install checks for 10gR2 RDBMS (10.2.x) - Linux x86 Platforms. (download it from metalink). https://metalink...

Hi

Be specific about OS Rel/Edition and Card Mfgr that would be helpful for ppl replying to your question. Anyway you need to check your network card is certified by Sun Solaris HCL. Check link below for that purpose.

Thanks

http://www.sun.com/bigadmin/hcl/search.jsp