Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with oracle
Search options not deleted
user 238149
All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.
0
votes
1
answer
34
views
About Oracle SGA architecture
new to oracle dba,
i wanted to ask about how the shared pool work especially about library cache and result cache
for example a session issues
select empname from employee where emp_id=10
and i issues …
- 13
1
vote
0
answers
283
views
How can i restore the tablestructure and recover data when i drop table column
i have some test table
create table test123(ids number,emp_name varchar(100));
next i insert 1 record into the table and commit the changes
insert into test123 values(1,'asdzxc')
after that i issue
…
- 13
0
votes
0
answers
564
views
Data pump exclude include
INCLUDE=TABLE:"LIKE'REG%'" query=regions:"region_name LIKE'Americas'" dumpfile=test12.dmp
Export: Release 19.0.0.0.0 - Production on Tue Oct 5 23:17:06 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle … Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "TEST"." …
- 13
0
votes
1
answer
852
views
All file in redo log group corrupt
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u02/oraredo/O12C/redo02b.rdo'
0RA-00312: online log 2 thread 1: '/u02/oraredo/O12C/redo02A.rdo'
i got …
- 13