SQL data type which allows whole numbers between -2,147,483,648 and 2,147,483,647
Questions tagged [sqllong]
3 questions
15
votes
2 answers
Workaround for ORA-00997: illegal use of LONG datatype
I want to save some data from a system table user_tab_cols, to a temp table so I can take a dump from it.
There are 100,000 rows in it , I have select from user_tab_cols about 1,000 records and d save them into a temp table with this query:
create…
Moudiz
- 7,211
- 22
- 78
- 156
0
votes
0 answers
Can changing the default location of the Microsoft SQL log in server properties cause unexpected behavior or any performance issue?
I have an application which is running on Mulesoft. The application connects to the database for basic authentication. Recently I made a change in the SQL Server properties to locate the default log location from C drive to D drive. I did not change…
0
votes
1 answer
ORA-00997: illegal use of LONG datatype: while creating a table with select statement
ORA-00997: illegal use of LONG datatype
I have created a dblink in Oracle between two database Ora1 & Ora2.
A table tab1 in Ora1 has column of LONG datatype, so while creating a table tab2 in ora2 with the following sybntax:
create table Ora2.tab2…
Pooja
- 327
- 1
- 5
- 20