Thank You All. But my main motive for this Query was to skip the process of rebuilding all the Indexes. You see for around 350 tables number of Indexes goes to more than 500. I have tried on 2 tables and its working fine. Is there any other way?
HI
I have some tables in my oracle Database which belongs to the same Owner(say MyUser). However some of the tables are in the tablespace - SYSTEM and some are in another user tablespace(say - MyTbs).
What will be the most eficient way to change the table in tablespace - SYSTEM to MyTbs...
HI
I have been trying to install the IDS in silent mode but the problem is that whenever I type the comand :- "setup.exe -s C:\TEMP\silent.ini -l C:\TEMP\silent.log" from the server product folder path nothing happens.
For your kind information I have already made the necessary...
I wanted to setup a server for Informix Dynamic Server which might be having an average user of 50 at a time and maximum upto 250 user at a time and have some 300 tables(tantative). I want to know the specific hardware specification for this server which will give the best performance. if...
Thank U all for all your consideration but I think I have found it. Its somthing like this:
select table_name from all_constraints where CONSTRAINT_NAME in (
select R_CONSTRAINT_NAME from all_constraints where CONSTRAINT_TYPE='R'
and upper(table_name) like upper('T2'))
Suppose if T1 is the...
Hi
How can we get all the tables refered by a particular Table Thourgh a SQL query? For eg T1 is the Parent table of T2, How can we get T1 corresponding to T2 through a query.
First of all I would like to thank U for Ur Piece of information. I knew we can use this package what I really wanted to know is somthing like.... what is the code of the procedure "DROP_QUEUE_TABLE".
And one more thing I have limited information about QUEUE tables any site where I...
HI
I'm some what confuse in this little prob.
I wanted to know if we can select the first 5 rows of any table with a single SQL query? If yes then How?
And mind U, it is not Indexed or a ordered View
Thank U for anyone who have read this and I'm open to any kind of sugestion.
Nishi
Hi
Everyone,
I'm bit confuse with this little problem.
Suppose I have a table of structure like
emp(emp_id,Name,salary)
How can I select the 5 highest paid employees with a single query?
And mind U, it is not Indexed or a ordered View
Thank U for anyone who have read this and I'm open to any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.