Select statement for locked files
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I'm looking for select statement displaying locked files by oracle.exe, such as log and bad files related to external tables.
oracle logging locking external
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
add a comment |
0
I'm looking for select statement displaying locked files by oracle.exe, such as log and bad files related to external tables.
oracle logging locking external
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
1
What do you mean by "locked files"? You can't do much to the external file system from within the database.
– eaolson
Nov 16 '18 at 15:29
1
I am pretty sure the database does not track this level of information about the state of operating system logfiles.
– William Robertson
Nov 17 '18 at 11:00
I'm talking about the files which are generated when oracle is reading file for external table. Such as log, bad and dis files. Looks like one of my log files remains locked after reading, no matter I'm using the exact same external table config for other tables.
– Beyond1337
Nov 19 '18 at 7:28
add a comment |
0
0
0
I'm looking for select statement displaying locked files by oracle.exe, such as log and bad files related to external tables.
oracle logging locking external
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
I'm looking for select statement displaying locked files by oracle.exe, such as log and bad files related to external tables.
oracle logging locking external
oracle logging locking external
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
asked Nov 16 '18 at 14:38
Beyond1337Beyond1337
33
33
1
What do you mean by "locked files"? You can't do much to the external file system from within the database.
– eaolson
Nov 16 '18 at 15:29
1
I am pretty sure the database does not track this level of information about the state of operating system logfiles.
– William Robertson
Nov 17 '18 at 11:00
I'm talking about the files which are generated when oracle is reading file for external table. Such as log, bad and dis files. Looks like one of my log files remains locked after reading, no matter I'm using the exact same external table config for other tables.
– Beyond1337
Nov 19 '18 at 7:28
add a comment |
1
What do you mean by "locked files"? You can't do much to the external file system from within the database.
– eaolson
Nov 16 '18 at 15:29
1
I am pretty sure the database does not track this level of information about the state of operating system logfiles.
– William Robertson
Nov 17 '18 at 11:00
I'm talking about the files which are generated when oracle is reading file for external table. Such as log, bad and dis files. Looks like one of my log files remains locked after reading, no matter I'm using the exact same external table config for other tables.
– Beyond1337
Nov 19 '18 at 7:28
1
1
What do you mean by "locked files"? You can't do much to the external file system from within the database.
– eaolson
Nov 16 '18 at 15:29
What do you mean by "locked files"? You can't do much to the external file system from within the database.
– eaolson
Nov 16 '18 at 15:29
1
1
I am pretty sure the database does not track this level of information about the state of operating system logfiles.
– William Robertson
Nov 17 '18 at 11:00
I am pretty sure the database does not track this level of information about the state of operating system logfiles.
– William Robertson
Nov 17 '18 at 11:00
I'm talking about the files which are generated when oracle is reading file for external table. Such as log, bad and dis files. Looks like one of my log files remains locked after reading, no matter I'm using the exact same external table config for other tables.
– Beyond1337
Nov 19 '18 at 7:28
I'm talking about the files which are generated when oracle is reading file for external table. Such as log, bad and dis files. Looks like one of my log files remains locked after reading, no matter I'm using the exact same external table config for other tables.
– Beyond1337
Nov 19 '18 at 7:28
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53339947%2fselect-statement-for-locked-files%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53339947%2fselect-statement-for-locked-files%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What do you mean by "locked files"? You can't do much to the external file system from within the database.
– eaolson
Nov 16 '18 at 15:29
1
I am pretty sure the database does not track this level of information about the state of operating system logfiles.
– William Robertson
Nov 17 '18 at 11:00
I'm talking about the files which are generated when oracle is reading file for external table. Such as log, bad and dis files. Looks like one of my log files remains locked after reading, no matter I'm using the exact same external table config for other tables.
– Beyond1337
Nov 19 '18 at 7:28