06-02-2016
Quote:
Originally Posted by
filosophizer
Sorry to say that, but this might not be the case. Maybe the database just isn't aware of the corrupted blocks.
Quote:
Originally Posted by
filosophizer
This is what I am thinking, export all data from applsysd02.dbf to temporary.dbf
delete applsysd02.dbf
create applsysd02.dbf in another filesystem
import data into applsysd02.dbf from temporary.dbf
No, no: an "export" is the dumping of the DBs (not only a single DB files) contents to a (human-readable) file, basically an ASCII-file. This will dump *all* the contents: table content, constraints, views, dependencies, and what else there is in the DB and cannot be created (like indices). From such a file you rebuild the complete DB by importing it into an empty container.
Does that answer your question?
I hope this helps.
bakunin
These 2 Users Gave Thanks to bakunin For This Post:
10 More Discussions You Might Find Interesting
1. Solaris
When I tried to decompress using TAR the following error was popped up..
tar: blocksize = 0
..Can anyone tell me wht this means and how to rectify this error... (3 Replies)
Discussion started by: hemin_pm
3 Replies
2. UNIX for Advanced & Expert Users
Hi
i am facing one problem with one file dxagent.ss, this file has most of the binary contents.
when i m running following command on unix machine
tar xpf dxagent.ss
output should be: removing leading '/' from members name. and should create 'usr' and 'var' directory.
but i am getting some... (5 Replies)
Discussion started by: yogini nemade
5 Replies
3. AIX
When Im trying to untar a file I get an error message
tar: 0511-169 A directory checksum error on media; 804399248 not equal to 46325.
What can I do to untar my file
Thanks (3 Replies)
Discussion started by: joemad
3 Replies
4. Solaris
Hi,
WHile decompressing the files, i get the error tar: directory checksum error. After decompressing when i check the size of file, it is less than the original file. Due to this error, there is loss of data. How can this error be removed?
Thanks in advance. (7 Replies)
Discussion started by: agarwal
7 Replies
5. Linux
Hi
when use "tar cpvzf /dev/st0 --exclude=/proc --exclude-/lost+found --exclude=/mnt --exclude=/media --exclude=/sys /" to tape,
get the following message "tar: error exit delayed form pervious error",
What is the mean ? Please suggest some solution for these errors. thx (1 Reply)
Discussion started by: chayato
1 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
4 files are returned when i issue 'find . -mtime -1 -type f -ls'.
./ora_475244.aud
./ora_671958.aud
./ora_934052.aud
./ora_934050.aud
However, when I issued the below command:
tar -cvf test.tar `find . -mtime -1 -type f`, the tar file only contains the 1st file -... (2 Replies)
Discussion started by: ahSher
2 Replies
7. Programming
A conditional statement cause it:
if(strlen(str) < n1+1) {
-------
} (7 Replies)
Discussion started by: cdbug
7 Replies
8. Shell Programming and Scripting
Dear all,
there are more than 10 files with .tar.gz extension in my folder i didnt want to extract them i just want to run the query to fetch my necessary data from all the files.
but when i run the command it untar the files in that folder.
gunzip -c abc.tar.gz | tar -xf - | grep REC |... (0 Replies)
Discussion started by: jojo123
0 Replies
9. Shell Programming and Scripting
Hi all,
I have a tar file and inside that tar file is a folder with additional tar.gz files. What I want to do is look inside the first tar file and then find the second tar file I'm looking for, look inside that tar.gz file to find a certain directory. I'm encountering issues by trying to... (1 Reply)
Discussion started by: bashnewbee
1 Replies
10. Shell Programming and Scripting
do you have idea what is the limit to zip the file.
+ tar -cvf - today.txt
tar: Size of today.txt >= 8GB. Not dumped. (3 Replies)
Discussion started by: ramkumar15
3 Replies
LEARN ABOUT DEBIAN
dbf_dump
DBF_DUMP(1p) User Contributed Perl Documentation DBF_DUMP(1p)
NAME
dbf_dump - Dump the record of the dbf file
FORMAT
dbf_dump [options] files
where options are
--rs output record separator (default newline)
--fs output field separator (default colon)
--fields comma separated list of fields to print (default all)
--undef string to print for NULL values (default empty)
--memofile specifies unstandard name of attached memo file
--memosep separator for dBase III dbt's (default x1ax1a)
--nomemo do not try to read the memo (dbt/fpt) file
--info print info about the file and fields
with additional --SQL parameter, outputs the SQL create table
--version print version of the XBase library
--table output in nice table format (only available when
Data::ShowTable is installed, overrides rs and fs)
SYNOPSIS
dbf_dump -fields id,msg table.dbf
dbf_dump -fs=' : ' table
dbf_dump --nomemo file.dbf
ssh user@host 'cat file.dbf.gz' | gunzip - | dbf_dump -
DESCRIPTION
Dbf_dump prints to standard output the content of dbf files listed. By default, it prints all fields, separated by colons, one record on a
line. The output record and column separators can be changed by switches on the command line. You can also ask only for some fields to be
printed.
The content of associated memo files (dbf, fpt) is printed for memo fields, unless you use the "--nomemo" option.
You can specify reading the standard input by putting dash (-) instead of file name.
AVAILABLE FROM
http://www.adelton.com/perl/DBD-XBase/
AUTHOR
(c) 1998--2011 Jan Pazdziora.
SEE ALSO
perl(1); XBase(3pm); index_dump(1p)
perl v5.12.4 2011-08-31 DBF_DUMP(1p)