ora-27091 ora-27067
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: ora-27091 ora-27067

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    ora-27091 ora-27067

    Hi Kuya,

    OS AIX 5L 5.2
    DB Ora10g 10.1.0.2

    I tried installing the 10g database for AIX and it gives me
    ora-27091 and ora-27067 when it started creating the sample
    database using DBCA.

    Has anyone encountered this error pls...


    Thanks again my friends

  2. #2
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi Kuya,

    I got it....i just missed to do the following:

    # chmod -R 775 /u01/app/oracle /u02/oradata


    Thanks

  3. #3
    Join Date
    Oct 2002
    Posts
    807
    Originally posted by kris123
    Hi Kuya,
    What or who is Kuya?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    finally someone asked what i daren't

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Isn't that Latin for zipperneck?
    I remember when this place was cool.

  6. #6
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    It's a synonym(respectful call) for loving/caring older brother.
    Everybody is my kuya here

  7. #7
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    well not really "old" as in....

  8. #8
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    By the way friends(KUYA), im reorganizing tables and tablespaces now.

    I want to transfer some tables to another tablespace coz i want to clean-up a certain tablespace and drop it. Is there a commnad like...

    ALTER TABLE table1 MOVE FROM tablespace1 TO tablespace2.
    or maybe a drag and drop tool in the OEM?

  9. #9
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38
    hi,

    If the tablespaces are within the same schema use can use the command
    Alter table *tablaname* move tablespace *new tablespacename*

  10. #10
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks hunie,

    I read some docs but i found examples for partitioned tables movement
    only...read more...search more...
    Sorry, but im quite confused....what is meant by tablespaces are within schema? Does it mean both are granted resource to the user?

    Say, if i have schema or user SCOTT, and i have 2 tablespaces TBLSPC1,
    and TBLSPC1, and i granted resource on these tablespaces to SCOTT,

    SQL> grant resource on TBLSPC1,TBLSPC2 to SCOTT;

    And if i have a table EMP on SCOTT, i can do this...

    SQL> alter table EMP move tablespace TBLSPC2;

    it worked!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width