This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Jan 23, 2013 2: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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    no sir it is resolved

    thank u very much
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points