Search results for query: *

Hi try using to_date('01/01/2010','dd/mm/yyyy') or simply pass the date in dd-mon-yyyy format and see if it helps khobar

Hi when u import the schema that schema has associated pl/sql packages/procedures which are getting imported probably that might be the reason khobar

Hi I beleive sp_help can also be used on tables to describe the columns. For procuedures use all_source For table just desc <tname> in sqlplus khobar

Hi May be you can try to use logminer to find out what are the sql statements issued on a particular table in a particular saved redolog file but may not be able to tell which user issued the sql statement. khobar

Hi you can use the below tables to query the columns user_tab_columns(tables owner by you) all_tab_columns ( for tables granted to you) khobar

Thanks for everybody who replied. I was using oracle 8i client sqlplus utility to execute the copy command on the oracle 9i database and there were some bugs reported on metalink. When i used oracle 9i client to login into sqlplus and executed copy command it worked regards khobar

Hi I have a table created with long datatype CREATE TABLE T1(ID NUMBER, text_data long); How do i copy/replicate to another table. If i use create table t2 as select * from t1 it doesn't work. In oracle 8i i used copy command as shown below copy from uid/pwd@inst to uid/pwd@inst...

Hi just a small clarification have you installed personnal oracle in your home pc ? In that case you cannot connect to the database through a network. Make sure you have installed Standard/Enterprise Edition khobar

Hi Have you enabled archive logging mode on ? In that case verify a. The archive logs are in a different device to reduce disk I/O. b. Veify there is sufficient space in the disk where archive logs are writeen if the archive logs are full the database comes to a halt khobar

Hi Added to dave's point you can get an extract of csv a. By using UTL_FILE command(Not sure oracle 7.0 supports it) b. You can use tools like toad query editor here you have an option to save the output in different tab limited format regards khobar

Hi just a small note if you have a sufficient hard disk space preferably in a different device you can backup all your datafiles into the disk rather than to a tape. In this way your recovery time is minimized(Recovering from hard disk will be faster than a tape). Offcourse it depends on...

Hi to modify the control file you need to follow the below steps a. Shutdown the database b. Move the control file to the desired location c. Modify the init.ora to point to the desired location d. Start the database To modify the datafiles get the list of datafiles files associated with...

Hi Ensure you have logged in as Impromptu Administator i.e. user 'Creator' when you open the catalog. Try to add the tables vittal

Badri Don't try to modify IQD directly instead go to Catalog-->joins and select outer Join and regenerate the IQD File based on this join

Hi I have opened a Business object report through the Universe option. The user will Enter the 'From Date' and 'To Date' using the standard prompts used by the Business Objects. Whenever the user Clicks Run Button I want to involke a stored procedure which will do some complex formaula and...

Hi I have a prompt department name which has the list MECH ELECT ELECT COMP There are three cases in the above for selecting the records from the dept table 1. The user can select only one department MECH in that case only the records related to MECH are displayed. 2. The user can...

Hi How do i call Business Object reports from Java Application. Is it possible to give a menu interface in Java application where if i click a report option it will call the Business Objects and open the report. Is it just a standard practice to open the Business object report directly and...

Hi all I have a report with 5 report paramters as a dropdowns and one paramter with 3 radio buttons in which the user has to select one of the option. What is the normal approach should i follow to display the report parameters. If i use prompts how can i simulate 3 radiobuttons ...

Hi I have created a VB form through a Insert Macro option which has two date fields 'From Date' and 'To Date' in B.O 5.0. Whenever the user runs the BO report it will automatically run the Macro and in the Macro I have specified UserForm1.Show to display the form. Once the user enters the...

Hi Can somebody advise me how to control the size of the Font, type of font etc for the prompts. If it is a cell in the result field i can do it using format cell option. But how do i standardize the font color, size etc for prompts or should i just accept what the BO provides as it is ? khobar