Search results for query: *

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

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.

HI How can I drop a Queue Table? Thanks

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