Skip to main content

Posts

Showing posts from November, 2009

ORA-01950: no privileges on tablespace

SQL> create table mith( n number primary key, l varchar2(60));
create table mith( n number primary key, l varchar2(60))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

Whenever a new user is created it requires certain previlages like connect, create any table, view etc along with grant on table space. To get rid of this error you can use the following sq,

1) GRANT UNLIMITED TABLESPACE TO MITH;

OR

2) ALTER USER MITH QUOTA 50M ON USERS;

Text Index -- Printjoins

I am trying to create a test case for one of my clients having issues with text index.

Text index comes with lot of options for language, lexer etc. It is not as simple as creating a normal index. Through my experience i have seen multiple issues with text indexes and one of which is with printjoins.

Details of Text index and its options can be found at,

http://download.oracle.com/docs/cd/B19306_01/text.102/b14218.pdf

and look at my other post on text index,

http://mithunashok.blogspot.com/2009/10/oracle-text-index-real-time-experience.html

User complains that when they search with . character it does not consider . as character. Look at the example below(tested on 10.2.0.1).


create table mith( n number primary key, l varchar2(60));

insert into mith values( 1, 'nisha.mithun');
insert into mith values( 2, 'nisha mithun');
insert into mith values( 3, 'nisha mithun nisha mithun');
insert into mith values( 4, 'hello-world');
insert into mith values( 5, 'hello@world…