Recent content by khobar

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...