f***e
发帖数: 17 | 1 谢谢大家的指导。
我log in 后用下面的command 对吗？
SQL> CONNECT SYS/change_on_install AS SYSDBA
然后用什么command 去 create tablespace? |
|
m******g
发帖数: 91 | 2 according to Oracle Admin Guide, it is like: (you need to tweak some
paths, names and sizes) |
|
h**h
发帖数: 132 | 3 hi, search google using 9i redhat as keywords. It should give you
some links on how to install 9.2 on redhat9 |
|
|
|
f***e
发帖数: 17 | 6 I want to copy an existing table and all its contents to a new table,
how to write the command?
thanks. |
|
n********a
发帖数: 68 | 7 create table foo as select * from bar; |
|
j*j
发帖数: 3 | 8 I need to debug a store procedure which use NCHAR data type from Oracle 9i.
The national char set is AL16UTF16 (UNICODE). I would like to watch variables
which are basically Chinese or Japanese. If anybody has experience, please
advise. Thanks. |
|
n********a
发帖数: 68 | 9 Oracle 9i has external table feature that may be helpful. |
|
m******t
发帖数: 2416 | 10
sometimes the oracle installer would pop up a dialog which gets
hidden behind the main window immediately. try minimizing all the windows
you can see and make sure there isn't a message dialog somewhere.
BTW, it's not the installer's fault, blame java for it. |
|
f********u
发帖数: 572 | 11 Hi, I checked, there was not any hidden dialog window...:( Oracle installer
is a such a trouble maker..never found any other software so troublesome to install.
One thing that I am not quite sure and someone reminded me that I might be wrong
is my setting of the shared memory. I followed an instruction I found online
to set the shared memory, but it did not work for me.
$su - root
$cat /proc/sys/kernel/shmmax
33554432
$echo 'expr 1024 \* 1024 \* 1024' > /proc/sys/kernel/shmmax
$cat /proc/sys/ker |
|
s***m
发帖数: 28 | 12 Try to check your ../../ctx/lib/ins_ctx.mk file. In 8i version, this makefile
is defective. The line "CTXHX_LINKLINE=$(LINK) $(CTXLIB)ctxhx.$(OBJ_EXT)
$(INSO_LINK) $(USRLIBS)" is missing a "-ldl" option.
Good Luck
install.
wrong
了。
在那个
选择 |
|
s*******e
发帖数: 151 | 13 Please tell me, if my database is put into a unix sever ( we are using oracle
9i ) and we lost sys Id and password, what can I do to recover them?
I use tetlnet to connect with that sever.
Please help,thanks a lot! |
|
t********k
发帖数: 808 | 14 怎么知道现在用的Oracle(用的是9i)的JDBC是哪个版本的?
如果用的是1.0的
怎么设置让Oracle用2.0版本的JDBC?
DB2都有批处理文件可以进行设置的 |
|
l***s
发帖数: 28 | 15 I recently start learning the Oracle 9i. I installed the Oracle
in Linux under user Oracle. So when I login as Oracle, I type
sqlplus
Then it asks me user and password. I am confused about this. Since
I have not been able to open the Oracle database yet, how can I
have a user and password for the database? I must be able to login
in as an administrator and for the first time I should have a
default password. Is this right? I learnt that I can prompt to
sqlplus without login. But can I do any adm |
|
a********r
发帖数: 28 | 16 谁能介绍一本学Oracle 8i/9i的书?
我原来懂一点,但只能说是皮毛
现在想学得精通一点
先谢谢了!
br />
br /> |
|
s*******e
发帖数: 151 | 17 if you want to be DBA, ,
Handbook> is useful.
If you want to be database developer, is good. |
|
B*******e
发帖数: 3882 | 18 看看oracle 9i complete reference 吧， 什么都讲了一点。 快速浏览一边应该不难，
如果有一定数据库的底子的话。 |
|
f*****e
发帖数: 1 | 19 不知 Oracle 9i 的Developer认证有什么好的参考书和网站论坛啊?
谢谢了. |
|
j**i
发帖数: 419 | 20 hehe, I passed 9i exam1 1-2 days before they starts to require people taking
classes.
I heard this news like Aug 20th, and they strats this like Sept 1st
JAVA.
knowledges. |
|
n********a
发帖数: 68 | 21 Ok, then check your network settings.
1. Is your listener running?
2. It seems that you are on Oracle 9i up, thus no need
to config listener.ora. Listener will detect instances
automatically. If this is not true, check listener.ora
first.
3. Can you connect with sqlplus @ipoll?
If not, check tnsnames.ora
4. If you are using advanced features like connection
manager or name servers instead of local naming, check
up the documentation to see if you have them configured
properly.
my
refused(DESCRIP |
|
w*******l
发帖数: 14 | 22 I think the listener is running. at least I can access database using SQL+.
It seems that I have to reconfigure the JDBC setup for Oracle 9i, differenct
from oracle 8. I downloaded the new driver and set up, but still errors
occured. Faint!!
PS: here is the listener.ora. Is there some error? Thanks a LOT!!
# LISTENER.ORA Network Configuration File:
C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDR |
|
|
aw
发帖数: 127 | 24 现在用到9I的都有限，别提10G了，这又不是买时装。 |
|
j**i
发帖数: 419 | 25
9i is better than 8i, why do you need 1G memory?
I installed it on machines with 500M ,runs OK. |
|
w**w
发帖数: 353 | 26 家里2台机器(XP,2003)都连在了路由器上，大部分的端口给了XP,
只有80和8080给了2003，装完Oracle 9i后，数据库可以启动，
Apache也可以启动，但Oracle Management Server无法启动，
OracleOraHome92ManagementServer 服务没法启动。
希望大虾指点一下，到底是怎么回事。谢谢了。 |
|
B*******e
发帖数: 3882 | 27 I am newbie in oracle too. I do not know how to resolve ur first problem,
since oracle 9i works fine after I installed it. :)
for the 2nd problem:
"From: Uwe Teichmann
Date: Mon, 18 Nov 2002 10:20:03 +0100
Message-Id: <2******************************[email protected]>
Subject: Re: [suse-oracle] DataBase Recovery
Jafar,
First, you need to install the Oracle Software only, no
creation of new database. When you setup your init.ora
file, be sure that the parameter CONTROL_FILES |
|
z***y
发帖数: 7151 | 28 支持超大内存。
在Oracle 9i 有一个称为超大内存的选项，他可以使Oracle 在32位平台上，通过使用共
享文件系统创建大小超过32位系统寻址范围的数据库和内存空间。 但是，在实际使用中
，我们发现在某些场合下， 由于在某一区域映射空间的方法，应用这一特性会造成内核
存储空间的碎片。由此导致在这片空间里能容纳的进程有限。
Oracle 通过与Red Hat 还有 SuSE合作，提供了一个API—Remap File Pages (文件页重
新映射)。 这个API已经包含在Red Hat Enterprise Linux 3 中，SuSE Linux
Enterprise Server 9 也将包含这个API. 由于Remap File Pages能够避免内存碎片以及
不使用低端内存，它能使系统提供更多更快的连接和稳定的性能。Linux Engineering at
Oracle 的主管Wim Coekaerts 介绍说:这个补丁已经包含在Oracle 10g 中，当用户使用
超大内存选项时，它将自动使用这一功能.
支持直接输入/输出。
以前，系统只支持针对Oracle 群集 |
|
l******n
发帖数: 9 | 29 求大侠帮忙
when I tried to install oracle 9i today,in the installation process, I made a
mistake, then I reboot the computer and tried to reinstall it, then the system
showed the
"certain files need to be reinstalled by oracle are being used by one running
service, the following service need to be shut down before continuing:
OracleMTSRecoveryService ".
I have no clue to deal with it. but my system didn't show that I have oracle
on my computer now.Can anyone do me a favour to tell me how to fix it? |
|
n*******s
发帖数: 4 | 30 除了参加ORACLE UNIV的课程,买它的STUDY CD-ROM, 还有什么办法?
买他们的太贵了!!! |
|
aw
发帖数: 127 | 31 ORACLE 9I，EXPERT ONE ON ONE |
|
c*****d
发帖数: 6045 | 32
in oracle latest version (maybe 9i), you can use
alter table rename column to |
|
w*r
发帖数: 2421 | 33 There are 4 Xeon processors,
when you say parallel operator, what exactly does it mean? does it mean the
slave thread? or something else.
VLM is mentioned in every oracle documentatoin since 9i, I only tried to use
it after I failed many times to make Oracle efficiently use memory
without generating this type of error. After VLM deployed, it seems that a
lot of queries which used to cause this error stopped throw exception out.
However, when I run the create MTV command with parallel option for |
|
I******e
发帖数: 101 | 34 > There are 4 Xeon processors,
What kind of I/O system do you have and how high throughput you can get? Do
you have 20 RAID disks which can make 8 CPUs happy?
> when you say parallel operator, what exactly does it mean? does it mean
the
> slave thread? or something else.
I mean an operator like hash join, or sort which are running in parallel?
>>>
VLM is mentioned in every oracle documentatoin since 9i, I only tried to use
it after I failed many times to make Oracle efficiently use memory
witho |
|
n******g
发帖数: 1 | 35 总是在最后的tools里, 安装database configuration assitant时最后一步,
complete database 时出问题, 提示ouput not available. 怎么回事? |
|
w*r
发帖数: 2421 | 36 ai,... 还是装一个linux，一切都简单明了 |
|
s**o
发帖数: 584 | 37 Not sure what kind of problem it is. But always try to avoid use XP Home for
any code development. |
|
h*****n
发帖数: 48 | 38 Books for Sale
因为近期要回国，所以特将一些崭新书籍在这里“销售”。
有数本计算机方面的书籍送人，你只要付邮寄费用就可以了。这些都是托人在国内买的
寄过来，但一直没有发挥用处，非常新。所以如有需要，请马上和我联系。
精通Office 2003技巧
Oracle 9i基础教程
Latex 2e及常用宏包使用指南
Fortran 95程序设计
PHP & MySQL Web数据库应用
数学工具软件及应用Mathematica几何画板Derive
SAS统计分析及应用
Maple高级应用和经典实例
SPSS统计分析实例精选
Photoshop7.0中文版入门与提高
谢谢！ |
|
f********t
发帖数: 74 | 39 Taking a class has been a request for OCP for long time. I did not take
class when I got OCA for 9i, but it is not the same case for 10g. |
|
c*****d
发帖数: 6045 | 40 在Oracle 8i，9i里面，肯定有影响
没有statistic，engine无法决定cost，只能用rbo |
|
B*****g
发帖数: 34098 | 41 how to write delete in merge? can not make it on 9i
some
will |
|
|
|
|
B*****g
发帖数: 34098 | 45 source?
just try code in oracle 9i, it works.
values.
can |
|
w*r
发帖数: 2421 | 46 ft... 你们算是快的了这里还刚上了9i... |
|
B*****g
发帖数: 34098 | 47 Oracle 9i
准备run
SELECT ...
FROM table1 a
WHERE a.col1 IS NULL
在col１上怎么建index?
已经知道
create ind_tab1_col1 ON table1( NVL(col1, 'NULL') )
极其不喜欢.
Thanks |
|
|
B*****g
发帖数: 34098 | 49 based on my test. 9i and 10g
to_char return char
'abc' is char
please confirm |
|
B*****g
发帖数: 34098 | 50 ft。今天就遇到了, 大家来分析一下。
oracle 9i, 36M rows tabA
Each row has 5 columns each with thousands bytes but <4000 bytes.(also other
columns,)
Not data warehouse, but also don't need 24*7(Sunday can stop everything)
Need add one new column colA with default value 'N'; and constraint on colA
(colA IN ('?', '?' ,'?'...).
No index on colA.
DBA created an empty column colA.
UPDATE value to 'N'. I was told after 6 hours not finish, so DBA stop the
process.
Now some records will have 'N', some will have NULL.
解决 |
|
