| Title: | Oracle |
| Notice: | For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010 |
| Moderator: | EPS::VANDENHEUVEL |
| Created: | Fri Aug 10 1990 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1574 |
| Total number of notes: | 4428 |
Hello, I installed Oracle 7.3.2.1.0 on DIGITAL UNIX 3.2G. I did not use any Oracle on that system before - so it is no upgrade!!! When trying to access a database via sqlplus, I get errors like STANDARD and DBMS_APPLICATION_INFO not available. I saw in the notes conference to run catproc.sql. When running $ORACLE_HOME/rdbms/admin/catproc.sql I get the following error messages: OER-1653: unable to extend table/cluster SYS.IDL_UB1$ by 41 in tablespace SYSTEM OER-1653: unable to extend ... SYS.SOURCE$ by 140 ... OER-1653: ... SYS.OBJ$ by 18 ... What is the command to extend these tablespaces? I have no idea, what datafile is meant. Where can I get more information about this? Thanx for any help. Christiane
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1555.1 | let oerr tell you | ALFAM7::GOSEJACOB | Wed Apr 30 1997 10:06 | 23 | |
re .0
The first thing to do:
oerr ora 1653
01653, 00000, "unable to extend table %s.%s by %s in tablespace %s"
// *Cause: Failed to allocate an extent for table segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
// files to the tablespace indicated.
Well that pretty much says it all. You still may want to check with
select * from dba_free_space;
to see if the system tablespace is filled up already. Btw. did you
create new database objects after the initial data dictonary load;
probably with a new user; probably without assigning a default
tablespace different from system to that user?
Hope this helps
Martin
| |||||