1

Topic: The order of columns in the table

At column adding in the table,  it is added in the end. Whether probably sorting of columns in the table to change the order?

2

Re: The order of columns in the table

Goofy122;
Create representation with the necessary order of columns and leave the table alone...

3

Re: The order of columns in the table

Kind  - Eh;
Thanks and I will make, and in the table there is no such function I correctly understood?

4

Re: The order of columns in the table

Goofy122;
Generally - is not present. If strongly it is necessary in the table, that correct will be -  it.

5

Re: The order of columns in the table

Kind  - Eh;
In 12 it is possible to be indulged with invisible/visible for columns, but without ALTER TABLE not to manage

6

Re: The order of columns in the table

MaximaXXL wrote:

Kind  - Eh;
In 12 it is possible to be indulged with invisible/visible for columns, but without ALTER TABLE not to manage

What for? To rely on  effect of not so qualitative implementation which it is fraught with any different by-effects?
[spoiler datadictionary vs physical storage]

SQL> create table t_part (id number, val varchar2 (100))
2 partition by range (id)
3 (partition p1 values less than (100));
Table created.
SQL>
SQL> alter table t_part modify id invisible;
Table altered.
SQL> alter table t_part modify id visible;
Table altered.
SQL> desc t_part
Name Null? Type
----------------------------------------- -------- ----------------------------
VAL VARCHAR2 (100)
ID NUMBER
SQL>
SQL> create table t_exch as select * from t_part where 1=2;
Table created.
SQL>
SQL> desc t_exch
Name Null? Type
----------------------------------------- -------- ----------------------------
VAL VARCHAR2 (100)
ID NUMBER
SQL>
SQL> alter table t_part exchange partition p1 with table t_exch;
alter table t_part exchange partition p1 with table t_exch
*
ERROR at line 1:
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

[/spoiler]
Regards
Maxim