Eric,
Q1: I think u were using direct path, use conventional path may avoid it or set env parameter NLS_LANG to AMERICAN_AMERICA.US7ASCII etc
--
On Wed, 17 May 2000 20:22:00 Eric Fang wrote:
>I just installed oracle8.1.5 on Sun Solaris. I loaded
>9m rows in a table. When I tried to do an export, I
>got the dollowing error:
>EXP-00041: Export done in server's WE8ISO8859P1,
>different from user's character set US7ASCII.
>
>Q: How can I set the character set to WE8ISO8859P1 on
>the unix box?
>
>Also I accidently drop a datafile for one of the
>rollback segment(I want to resize the rbs):
>I drop the rollback segment,tablespace(forgot to
>delete the o/s file), then when I created the
>tablespace, I got the error of the file already
>existed. Then I deleted the o/s file, tried to create
>ts again, I got the error of TS already existed but
>the datafile cannot found.
>
>Q: the database in in noarchive log mode, how can I
>drop the tablespace(which doesn't have datafile), I am
>still able to use the database though and the database
>is just created but I don't want to load the 9m rows
>again.
>
>Thanks in advace.
>
>Eric Fang
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: Eric Fang
> INET: eric_fang_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get your FREE Email at http://mailcity.lycos.com
Get your PERSONALIZED START PAGE at http://my.lycos.com
Received on Thu May 18 2000 - 20:43:42 CDT
