| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Two (newbie) questions
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
 |
 |