ora-27091 ora-27067

[kris123]

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

[kris123]

Hi Kuya,

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

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


Thanks

[Axr2]

Originally posted by kris123
Hi Kuya,

What or who is Kuya?

[davey23uk]

finally someone asked what i daren't

[Mr.Hanky]

Isn't that Latin for zipperneck?

[kris123]

It's a synonym(respectful call) for loving/caring older brother.
Everybody is my kuya here

[kris123]

well not really "old" as in....

[kris123]

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?

[Akila]

hi,

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

[kris123]

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!