Max Extents Error

Hi,   I have a table which consists of Long Raw column in addition to other columns of Number and Varchar2 datatypes.   I have the datafile size set to 2GB. The average length of the messages goes up to 100M, sometimes more than that.   I have now added three datafiles to that tablespace each

Oracle Installation on DiskArray

Hi,   Thanks to those who replied. I was wondering whether which RAID level to implement.   My database is not a very critical 24x7 database. It is a development database. There are going to be only a few users accessing this database. Infact the data as such is not very important as it is te

Oracle Installation on DiskArray -

Hi,   My company is planning to install Disk Array on Solaris. After that, I am going to install Oracle.   I just wanted to know whether is there any special consideration or steps to be taken to install Oracle on this Solaris? If so what are the steps? Where can I get that steps from?   I a

Help with Oracle

Hi,   I want to display the data from few tables into Excel sheet. How do I do that?   Is there any tool available?     Sanjay 

Document Preparation for a table

Hi,     I am asked to prepare a document listing all possible suggestions for an effective tuning of a single table.   The table has five to six columns with one column having a Long Raw datatype. The average row that gets into the database is about 1GB.   Could anyone give me possible sugg

Re: Table Storage Estimates

iles as the data should not occupied more than 3200K if you blocksize is 16K. Increase the size of the initial datafile instead of adding new ones. --- Sanjay Kumar <[EMAIL PROTECTED]> a écrit : > Hi, > > I have a table which has a structure similar to the > following. > > MID

Table Storage Estimates

Hi,   I have a table which has a structure similar to the following.   MID NOT NULL VARCHAR2(24)NAME           VARCHAR2(512)PRIORITY   NUMBER(38)PERSISTENT   

SQL Text

hi,   I want to see the latest SQL Statements that I sent to Database. I know that I can make use of V$sqlarea but it restricts only to first 1000 characters. But my query is more than that.   Any help.   Sanjay

Oracle JDBC Thin Driver Licensing Issue

hi,   Does anyone know whether Oracle JDBC Thin Driver can be shipped  to the clients without getting any license from Oracle?.   Is it free for shipping?   Sanjay    

Re: User objects in System tablespace

Thanks to those who responded.   I also have another question.   How do I distinguish between the non-system tables and system tables.?   This user has created all the application related tables as User SYS. I would like filter them and give a new tablespace.   Thanks Sanjay   - Origin

User objects in System tablespace

Hi,   I have a situation where in all the user related objects (tables) have been created in System tablespace.   I believe there is no convention followed while creating these tables.   Now, how do I separate these user related objects and put them in Users tablespace?   Vinay

Backup and Recovery Question

Hi,   I have a situation like this.   I found a user dropping a table today at 9 AM but I came to know about that only at 2 PM the same day. I have a backup which was taken the previous day at 4 PM. My database runs in Archivelog mode.   I want to restore the table. If I put the database in

PlusTrace not getting enabled

Hi,   I ran the Plustrace.sql as user System. Then I granted that role to user Scott. After I log in as User Scott and try to set the autotrace on, it gives me a error   SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS report

Optimizer Question

Hi,   I have a column in a table which has four values namely, open, closed, active, assigned.   I would like to query that table based on that column. There are two ways of doing this.   1. Select column1, column2 from table where column1 != 'CLOSED';   2. Select column1, column2 from table