Questions tagged [oracle-11g]
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
717 questions
5
votes
5
answers
1k
views
Dummy statement to check connection, has to be supported by Oracle, Postgres
This won't work in Postgres since it doesn't have any DUALs.
SELECT 'Ok' AS RESULT FROM DUAL
On the other hand, this won't work in Oracle since it requires a FROM clause
SELECT 'Ok' AS RESULT;
The ...
- 263
0
votes
0
answers
149
views
SQLDeveloper encoding and export database
I've been requested to make a dump of an Oracle 11g EE Database. However, i can't use the Oracle Data Pump utility, since I have no direct access to the host machine, nor I think the db user have the ...
1
vote
0
answers
40
views
Link DB Oracle11g to Oracle19c
Question?
is there a way or possible way to Connect Oracle11g and Oracle19c Database
the Scenario is Oracle11g Table1 transfer specific Columns of data to Oracle19c Table2
same column structure for ...
- 11
0
votes
0
answers
60
views
ORA-02292: integrity constraint (CITY_COUNTRY_FK) violated - child record found
I am trying to make my all table columns in lowercase but the following error appears:
SQL> UPDATE COUNTRY SET country_code = LOWER(country_code);
UPDATE COUNTRY SET country_code = LOWER(...
- 17
0
votes
1
answer
320
views
Oracle instance automatically starting after SHUTDOWN IMMEDIATE command
DB: 11g Release 11.2.0.3.0
OS: RHEL server 5.8
I'm trying to shutdown an oracle instance, but every time I try the following ORA-03113 error appears and the instance restarts itself:
sys@db_name> ...
0
votes
1
answer
223
views
Calculate (n) workdays from a given date, using a calendar table
As shown on below image, I have two tables;
Customer : with about 4 million records; and 3 columns
[Customer] : Customer ID
[Date] : Creation date
[Num_Days] : Number of working days to calculate ...
- 1
-3
votes
1
answer
83
views
MYSQL workbench like gui tool for oracle 10 g or more
I am a java full stack developer who want to write oracle sql queries to simplify writing is there any mysql workbench like similar gui tool for oracle by oracle or any other please sugest
1
vote
1
answer
402
views
Updating an oracle updatable view through an oracle_fdw foreign table in PostgreSQL fails with ORA-02014
I created an updatable view V1 in an Oracle 11g DB (it has INSTEAD OF triggers for UPDATE, DELETE and INSERT); it originally had a GROUP BY query in it, which I moved to another view V2. This other ...
- 406
0
votes
1
answer
3k
views
ORA-32771: Cannot Add File To Bigfile Tablespace
I have 1TB tablespace that have one bigfile , The disk size now full and added extra disk to my server but there is no way to expand Drive that bigfile in it , so need to add another bigfile ,if ...
0
votes
0
answers
281
views
Top reasons for temp tablespace to go offline
It was marked offline and it is fixed already.
We want to know the list of causes that marks the temp tablespace offline.
0
votes
2
answers
2k
views
expdp fails with error ORA-31626 without any details on a full export
I am exporting a complete database (full=y) on oracle 11gR2 on Linux, and always get this error. There are no other messages, so the problem is not about timeout or permissions as shown elsewhere. ...
- 5,142
1
vote
1
answer
1k
views
What are the ways to recover Oracle database that has corrupted data file, very old RMAN full backup, and incomplete/corrupted archived logs?
For an Oracle 10g/11g database that refuses to start due to datafile (SYSTEM01.DBF) corruption, does RMAN restore command immediately overwrite all current datafiles from the last found full RMAN ...
- 11
1
vote
1
answer
2k
views
Improving OPENQUERY performance from Oracle to SQL Server
I'm currently working on a database migration, from Oracle 11g to SQL Server 2019. We're talking here of about 10-12 GB, in something like 300 tables (so creating them manually is out of reach, as is ...
- 13
1
vote
1
answer
3k
views
Receiving error "can not access rows from a non-nested table item" while working with associative arrays
Below , I'm trying to use the data of the array I've declared,
in the where clause of the query but I receive the following error :
declare
v_input varchar2(400) := '0,1,2,3,4';
type ...
- 1,502
-1
votes
1
answer
244
views
How to restore a Oracle Database if i only have the datafiles?
My Oracle database Test server crashed, I have no rman backups but I still have the datafiles because they are on a SAN Storage, so if I have datafiles, how can I restore my Oracle database?
- 29