Search results for query: *

I think you might have figured out the answer you were looking for. Anyway, the correct sql would have been select owner,table_name from all_tab_columns where column_name='YOUR_COLUMN_NAME';

How can I find the number of CPUs in my unix server? thanks in advance kindus

Hi David, In Oracle8i we can create GLOBAL temporary table which can be either TRANSACTION specific or SESSION specific, data remain consistent within the transaction or session. So if you are thinking for disconnecting the seesion than global temporary table will not be helpfull. So far as...

Try this sysdef |grep -i semmns I donot exactly remember whether it works in HPUX.

The problem is with your passing the partition name, oracle sees the partition name as paticao not as its value. You need to treat the partition name just like table_name.You have to either hard code the partition name or use dynamic sql to resolve the issue.

I donot see any problem with your query, nor it is to be done with dynamic sql. What I can think is your partition name may be misspelled. check it with select table_owner,table_name,partition_name from dba_tab_partitions where table_name='POSTPS_SUCCESSFUL_CALLS' / Let us know.

Hi, I have not heard of Transparent Gateways. We do work with teradata, and used combination of sqlload, pro*c and informatica. Reasons being many ....some business demands, some becos of performance or some just because we are just lazy/busy to convert exisiting tools to newer. If you provide...

Few things 1) To check which tablespace is temporary, query dba_tablespaces, not in other dictionary tables as those may be give partial result which may be undesirable. select tablespace_name from dba_tablespaces where contents='TEMPORARY'; 2) Carp's script above will work except in case your...

Is anybody familiar with hash function oracle used to determine the hash value in case of hash partitioning. e.g. for a table is partioned into 4 hash partitions and key is number data type, which values will go to Partition 1, 2 ,3 and 4. I tried inserting continous set of values from...

Make sure the following and try again. 1) listener at the destination db is configured and running 2) tnsnames.ora is configured at the source db for the destination db 3) database link is created with proper service name as defined in the tnsnames.ora 4) destination database is up and running

One thing is very clear. you need partitioning by range in terms of months, one each for each month. So far the possible values of a column, question is whether you want subparitioning, the answer could be "may be not". What I can see is range partitioning on date and local partition...

Hi Binjovi, I just read this posting today as it came up due to some unrelated posting though. I think u must have resolved your issue, but since it is not posted here I am putting what I think might be happening in your trigger. There is an option of defining trigger an autonomous transation...

To ensure that your encrypted password is correct, first change it some u want. LSNRCTL>change_password It will ask for old password, enter foobar then new password, enter <newpassword> It will get password changes successfully. Before giving stop command ALWAYS use LSNRCTL>set password...

Hi Sonix, I misinterpreted you question. I thought you wanted to pass sql statements to svrmgrl prompt. Now I think I got you. The answer what you are looking is procedure with dynamic sql. create procedure create_ts (ts varchar2, df varchar2, size_in_meg number) is begin execute immediate...

This should do for you, svrmgrl <! your statements; ..... ! All statement between ! and ! will be executed under svrmgrl.

Hang on Guys, Actually &quot;SET ECHO OFF&quot; should do the trick for you. But what is bothering me is I could see that line in your script. I donot know whether ECHO doesnot go along with some set commands you specified, but I think you echo may be on. You may check by puttig only the ECHO...

I mostly agree with Terry, Anyway here is what terry is telling .... select substr(yoursentence,1,instr(yoursentence,' '))||substr(yoursentence,instr(yoursentence,' ',1,2)+1,length(yoursentence))from dual; Hope it meets your need.

Hope following example helps u set serveroutput on declare a number; begin delete emp where emp_id=3; a := sql%rowcount; dbms_output.put_line(a); end; / ~kindus

May be User is having DBA role, you may forget all those. Here it is how you can achieve what u want. Login as user_b 1) create table <yourtable> tablespace tablespace_b as select * from user_a.<yourtable> where 1=2 2) import ....... ignore=Y Specify other import parameters which are...

I think your database auditing is not on. Please check your init.ora file where there is a entry &quot;audit_trail = db&quot;. If not u need to enter that and restart your database. After restarting you may enter you audting statements and check AUD$ table. To understand options of auditing you...