执行完上述语句后,还是有问题啊 SQL> Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tabl espace_Name; Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tablespac e_Name * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only 请问该如何处理呢?
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 27 10:01:19 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEMConnected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production 建立完表空间和用户然后登陆的时候出错,请问该如何处理,执行的@$ORACLE_HOME/sqlplus/admin/pupbld.sql,执行后也出错错误如下: SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql DROP SYNONYM PRODUCT_USER_PROFILE * ERROR at line 1: ORA-01434: private synonym to be dropped does not exist DATE_VALUE FROM PRODUCT_USER_PROFILE * ERROR at line 3: ORA-00942: table or view does not exist DROP TABLE PRODUCT_USER_PROFILE * ERROR at line 1: ORA-00942: table or view does not exist ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG) * ERROR at line 1: ORA-00942: table or view does not existTable created.DROP TABLE PRODUCT_PROFILE * ERROR at line 1: ORA-00942: table or view does not exist DROP VIEW PRODUCT_PRIVS * ERROR at line 1: ORA-00942: table or view does not exist 等等。请问该如何处理。谢谢
database not open: queries
楼上的别说的那么简单,偶是菜鸟,基本对oracle不熟悉,请详细解释下,谢谢了
create user **** identified by "password" DEFAULT TABLESPACE atmv;
SQL> Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tabl
espace_Name;
Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tablespac
e_Name
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
请问该如何处理呢?
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEMConnected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
建立完表空间和用户然后登陆的时候出错,请问该如何处理,执行的@$ORACLE_HOME/sqlplus/admin/pupbld.sql,执行后也出错错误如下:
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
DATE_VALUE FROM PRODUCT_USER_PROFILE
*
ERROR at line 3:
ORA-00942: table or view does not exist
DROP TABLE PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG)
*
ERROR at line 1:
ORA-00942: table or view does not existTable created.DROP TABLE PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist
DROP VIEW PRODUCT_PRIVS
*
ERROR at line 1:
ORA-00942: table or view does not exist
等等。请问该如何处理。谢谢