1 2 Previous Next 19 Replies Latest reply: Jan 23, 2013 4:19 AM by 899401 Go to original post RSS
      • 15. Re: unable to extend table INFA_USER2.OPB_DTL_SWIDG_LOG by 128 in tblespce USER
        899401
        third output

        DATAWAREHOUSE     FLASHBACK ARCHIVE ADMINISTER     NO
        DATAWAREHOUSE     DELETE ANY MEASURE FOLDER     NO
        DATAWAREHOUSE     MANAGE ANY FILE GROUP     NO
        DATAWAREHOUSE     MANAGE FILE GROUP     NO
        DATAWAREHOUSE     ADMINISTER RESOURCE MANAGER     NO
        DATAWAREHOUSE     QUERY REWRITE     NO
        DATAWAREHOUSE     ALTER ANY OPERATOR     NO
        DATAWAREHOUSE     GRANT ANY PRIVILEGE     NO
        DATAWAREHOUSE     DROP PROFILE     NO
        DATAWAREHOUSE     DROP ANY TRIGGER     NO
        DATAWAREHOUSE     CREATE ROLE     NO
        DATAWAREHOUSE     CREATE ANY SYNONYM     NO
        DATAWAREHOUSE     DROP ANY CLUSTER     NO
        DATAWAREHOUSE     ADMINISTER SQL MANAGEMENT OBJECT     NO
        DATAWAREHOUSE     SELECT ANY CUBE     NO
        DATAWAREHOUSE     CREATE ANY CUBE     NO
        DATAWAREHOUSE     SELECT ANY CUBE DIMENSION     NO
        DATAWAREHOUSE     CREATE ANY ASSEMBLY     NO
        DATAWAREHOUSE     ADMINISTER ANY SQL TUNING SET     NO
        DATAWAREHOUSE     EXECUTE ANY PROGRAM     NO
        DATAWAREHOUSE     DROP ANY RULE     NO
        DATAWAREHOUSE     EXPORT FULL DATABASE     NO
        DATAWAREHOUSE     DROP ANY EVALUATION CONTEXT     NO
        DATAWAREHOUSE     DROP ANY CONTEXT     NO
        DATAWAREHOUSE     MANAGE ANY QUEUE     NO
        DATAWAREHOUSE     DROP ANY DIMENSION     NO
        DATAWAREHOUSE     ALTER ANY INDEXTYPE     NO
        DATAWAREHOUSE     DROP ANY TYPE     NO
        DATAWAREHOUSE     ALTER ANY TYPE     NO
        DATAWAREHOUSE     CREATE TYPE     NO
        DATAWAREHOUSE     DROP ANY MATERIALIZED VIEW     NO
        DATAWAREHOUSE     CREATE ANY MATERIALIZED VIEW     NO
        DATAWAREHOUSE     CREATE MATERIALIZED VIEW     NO
        DATAWAREHOUSE     ANALYZE ANY     NO
        DATAWAREHOUSE     ALTER PROFILE     NO
        DATAWAREHOUSE     DROP ANY ROLE     NO
        DATAWAREHOUSE     CREATE ANY SEQUENCE     NO
        DATAWAREHOUSE     DROP ANY INDEX     NO
        DATAWAREHOUSE     ALTER ANY INDEX     NO
        DATAWAREHOUSE     ALTER ANY CLUSTER     NO
        DATAWAREHOUSE     DROP ANY TABLE     NO
        DATAWAREHOUSE     BACKUP ANY TABLE     NO
        DATAWAREHOUSE     ALTER ANY TABLE     NO
        DATAWAREHOUSE     CREATE TABLE     NO
        DATAWAREHOUSE     ALTER USER     NO
        DATAWAREHOUSE     UNLIMITED TABLESPACE     NO
        DATAWAREHOUSE     MANAGE TABLESPACE     NO
        DATAWAREHOUSE     CREATE CUBE BUILD PROCESS     NO
        DATAWAREHOUSE     INSERT ANY CUBE DIMENSION     NO
        DATAWAREHOUSE     ALTER ANY EDITION     NO
        DATAWAREHOUSE     CREATE ANY SQL PROFILE     NO
        DATAWAREHOUSE     CREATE ANY JOB     NO
        DATAWAREHOUSE     ALTER ANY RULE     NO
        DATAWAREHOUSE     IMPORT FULL DATABASE     NO
        DATAWAREHOUSE     DROP ANY RULE SET     NO
        DATAWAREHOUSE     CREATE RULE SET     NO
        DATAWAREHOUSE     FLASHBACK ANY TABLE     NO
        DATAWAREHOUSE     DEBUG ANY PROCEDURE     NO
        DATAWAREHOUSE     ADMINISTER DATABASE TRIGGER     NO
        DATAWAREHOUSE     CREATE ANY OUTLINE     NO
        DATAWAREHOUSE     DEQUEUE ANY QUEUE     NO
        DATAWAREHOUSE     UNDER ANY TABLE     NO
        DATAWAREHOUSE     DROP ANY LIBRARY     NO
        DATAWAREHOUSE     CREATE ANY LIBRARY     NO
        DATAWAREHOUSE     UNDER ANY TYPE     NO
        DATAWAREHOUSE     CREATE PROFILE     NO
        DATAWAREHOUSE     ALTER ANY TRIGGER     NO
        DATAWAREHOUSE     CREATE TRIGGER     NO
        DATAWAREHOUSE     AUDIT ANY     NO
        DATAWAREHOUSE     CREATE PUBLIC DATABASE LINK     NO
        DATAWAREHOUSE     CREATE PUBLIC SYNONYM     NO
        DATAWAREHOUSE     CREATE ANY TABLE     NO
        DATAWAREHOUSE     DROP TABLESPACE     NO
        DATAWAREHOUSE     DROP ANY MEASURE FOLDER     NO
        DATAWAREHOUSE     CREATE ANY CUBE DIMENSION     NO
        DATAWAREHOUSE     CREATE MINING MODEL     NO
        DATAWAREHOUSE     ALTER ANY ASSEMBLY     NO
        DATAWAREHOUSE     ADMINISTER SQL TUNING SET     NO
        DATAWAREHOUSE     ALTER ANY SQL PROFILE     NO
        DATAWAREHOUSE     EXECUTE ANY CLASS     NO
        DATAWAREHOUSE     CREATE JOB     NO
        DATAWAREHOUSE     ADVISOR     NO
        DATAWAREHOUSE     CREATE ANY RULE     NO
        DATAWAREHOUSE     ALTER ANY EVALUATION CONTEXT     NO
        DATAWAREHOUSE     DEBUG CONNECT SESSION     NO
        DATAWAREHOUSE     MERGE ANY VIEW     NO
        DATAWAREHOUSE     CREATE INDEXTYPE     NO
        DATAWAREHOUSE     EXECUTE ANY LIBRARY     NO
        DATAWAREHOUSE     DROP ANY DIRECTORY     NO
        DATAWAREHOUSE     ALTER RESOURCE COST     NO
        DATAWAREHOUSE     CREATE ANY TRIGGER     NO
        DATAWAREHOUSE     EXECUTE ANY PROCEDURE     NO
        DATAWAREHOUSE     FORCE TRANSACTION     NO
        DATAWAREHOUSE     SELECT ANY SEQUENCE     NO
        DATAWAREHOUSE     DROP ANY SEQUENCE     NO
        DATAWAREHOUSE     CREATE SEQUENCE     NO
        DATAWAREHOUSE     DROP ANY VIEW     NO
        DATAWAREHOUSE     CREATE ANY VIEW     NO
        DATAWAREHOUSE     DROP ROLLBACK SEGMENT     NO
        DATAWAREHOUSE     AUDIT SYSTEM     NO
        DATAWAREHOUSE     CREATE ANY CUBE BUILD PROCESS     NO
        DATAWAREHOUSE     DROP ANY CUBE     NO
        DATAWAREHOUSE     CREATE CUBE DIMENSION     NO
        DATAWAREHOUSE     CREATE ANY MINING MODEL     NO
        DATAWAREHOUSE     DROP ANY ASSEMBLY     NO
        DATAWAREHOUSE     DROP ANY EDITION     NO
        DATAWAREHOUSE     CREATE ANY EDITION     NO
        DATAWAREHOUSE     CREATE EXTERNAL JOB     NO
        DATAWAREHOUSE     CHANGE NOTIFICATION     NO
        DATAWAREHOUSE     EXECUTE ANY RULE     NO
        DATAWAREHOUSE     EXECUTE ANY RULE SET     NO
        DATAWAREHOUSE     ALTER ANY RULE SET     NO
        DATAWAREHOUSE     CREATE ANY EVALUATION CONTEXT     NO
        DATAWAREHOUSE     CREATE EVALUATION CONTEXT     NO
        DATAWAREHOUSE     DROP ANY OUTLINE     NO
        DATAWAREHOUSE     CREATE ANY CONTEXT     NO
        DATAWAREHOUSE     CREATE ANY DIMENSION     NO
        DATAWAREHOUSE     CREATE DIMENSION     NO
        DATAWAREHOUSE     EXECUTE ANY INDEXTYPE     NO
        DATAWAREHOUSE     DROP ANY INDEXTYPE     NO
        DATAWAREHOUSE     EXECUTE ANY OPERATOR     NO
        • 16. Re: unable to extend table INFA_USER2.OPB_DTL_SWIDG_LOG by 128 in tblespce USER
          Fran
          several points:

          1) Your user tablespace is almost full, this is the cause:
          Status    Name    Type             Ext Man     Size (M)        Used (M)      Used %
          ---------   ----------- ----------------   ----------     ---------------    ---------------    -------
          ONLINE  USERS     PERMANENT   LOCAL        37,556.984     35,822.672      95.38
          2) Your user has dba privileges. He has extra privileges, nothing to do:
          DATAWAREHOUSE     DBA     NO     YES
          My question is:
          are you sure you add the datafile correctly?

          post result of :
          SQL> select file_name, bytes/1024/1024 "Mb",maxbytes/1024/1024 "max_Mb", status, increment_by from dba_data_files where tablespace_name='USERS';
          • 17. Re: unable to extend table INFA_USER2.OPB_DTL_SWIDG_LOG by 128 in tblespce USER
            899401
            Hi,

            here is the output
            mb max mb status increamented by
            C:\APP\VSHADMIN\ORADATA\ORCL01\USERS01.DBF     32767.984375     32767.984375     AVAILABLE     134400
            C:\APP\VSHADMIN\ORADATA\ORCL01\USERS05.DBF     2395     32767.984375     AVAILABLE     1
            D:\APP\USERS06.DBF     2394     32767.984375     AVAILABLE     1

            thanks
            • 18. Re: unable to extend table INFA_USER2.OPB_DTL_SWIDG_LOG by 128 in tblespce USER
              Fran
              are you seriously still having "ORA-1653: unable to extend table "?

              if yes: post how are you creating the table, the errors showed by alert.log and from what user are you running the statement.
              • 19. Re: unable to extend table INFA_USER2.OPB_DTL_SWIDG_LOG by 128 in tblespce USER
                899401
                no sir it is resolved

                thank u very much
                1 2 Previous Next