ERPstuff - Oracle EBS Community

Hello

Is there any way to find out the customized reports scattered in different modules? before upgrade.

Thanks?

Hi there

Using a Java stored procedure it is possible to perform shell commands from PL/SQL.

If you need Java coding let me know.

Thanks

Hi Lukman You seem to be littlie bit confused. Nevermind, that's a DBA issue. To restore backup your database should be in atleast MOUNT state. SQL> STARTUP MOUNT; O.K if it's not in NOMOUNT state. Now to get it in mount state, 1st I wud find PFILE or INIT.ora file if it's not there. Try to find it ...

Hi

What type of error you are getting? did you try Netscape and getting same error overthere?

Thanks

Thanks a bunch... that was really awosome![:o)]

Hello

There is a perl utility to prepare stage. If your platform is WINDOWS you need to install VC98 and MKSTOOLS with gnumake.

But be carefull all directories and file names should not exceed 8 chars.

Have fun.

Hi If you have changed your INIT file and bounced your DB it's suppose to be working. anyway try this one...if doesn't work send the output again. SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP MOUNT; SQL> ARCHIVE LOG LIST; SQL> ALTER DATABASE ARCHIVELOG; SQL> ALTER SYSTEM ARCHIVE LOG START; SQL> ARCHIVE LOG...

Hi there


Any idea? how much additional space required to add/Install each language support in 11i. I have US installed and told to add French support.


You ASAP reply highly appreciated.

Thanks

Hello

Can I get table wise record count of a schema. Like I need record count of all SCOTT tables from user_tables. Instead of mentioning name of tables explicitly?

After changing domain, to take effects in APPS you need to run autoconfig or adautocfg.

Thanks

Hello! Sorry to say... nobody seems to answer my questions[:(!] mite be difficult/stupid...O.K I'm not gonna giveup[;)] I request to ADMIN plz provide us any link or method for easy setup of Oracle workflow. That wud be great help for APPLICATOINS using APPROVAL HIRERACY. Thanks NOTE: I've already g...

Hi there

I'm planning to buy new Linux Server. Can anybody tell me how much RAM+HDD+Processor(s) are good to run 11i at home for practice purpose.

Thanks

Hti Tahir It often happend with date/time type data. what you need to do is add a temporary column to the table with type CHAR and insert all your data of BILL_MONTH overthere. You can issue command below to replace all your actual values in BILL_MONTH column. SQL> UPDATE tablename SET bill_month = ...

Hi Najm You have to move table 1 by 1 issuing a command on SQL prompt. (workaround: can write a script to move all tables of that schema). here is syntax. ALTER TABLE tablename MOVE newtablespacename CAUTION: You might need to rebuild indexes related to that schema. you can use script below to autom...

Thanx Dude, that was awosome.

Have a great day.