-Bir tabloda birden fazla LONG yada LONG RAW sütunu oluşturmak mümkün değildir.
Create table kaynak_long (long_dt LONG);
insert into kaynak_long values('long bir veri tipi girdim');
create table hedef_long as select * from with_long
burada ORA-00997: illegal use of LONG datatype hatasını alacaksınız. Bunu aşmanın yöntemi LONG veri tibi LOB yada BLOB veri tipine dönüştürmekten geçiyor.
Bunu açiklayan bağlantı ise http://www.dba-oracle.com/oracle_news/2005_5_9_converting_long_lob_data_types.htm
LONG datatype in sınırlamalarını listelemek gerekir ise
•LONG datatype store variable-length character strings containing up to 2 gigabytes -1, or power(2,31)-1 bytes.
The use of LONG datatype is subject to the following restriction.
•A table can contain only one LONG column.
•You cannot create an object type with a LONG attribute.
•LONG columns cannot appear in WHERE clauses or in integrity constraints (except that they can appear in NULL and NOT NULL constraints).
•Index can't be created on LONG columns.
•In regular expressions LONG datatype can't be specified.
•Stored function can't return a LONG value.
•You can declare a variable or argument of a PL/SQL program unit using the LONG datatype. However, you cannot then call the program unit from SQL.
•LONG and LONG RAW columns can't be replicated.
•All LONG columns, updated tables, and locked tables must be located on the same database within an SQL statement.
•LONG column can't appear in GROUP BY, ORDER BY clause, UNIQUE / DISTINCT operator or CONNECT BY clause in SELECT statements.
No comments:
Post a Comment