Sponsored Content
Top Forums Programming Oracle simple SQL query result in: ORA-08103: object no longer exists Post 302962016 by durden_tyler on Monday 7th of December 2015 11:47:07 AM
Old 12-07-2015
What is the partition key in your table? Or, which columns form a partition in your table? What type of partitioning is being used?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi , I just found you while surfing for the string 'Redirecting sql select query output from within a shell script to txt file/excel file' Could you find time sending me the code for the above question? It'll be great help for me. I have a perl file that calls the sql file... (1 Reply)
Discussion started by: dolphin123
1 Replies

2. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies

3. Shell Programming and Scripting

How to Format the result driven from a SQL Query

Hi All, I want to format the result driven from the query into neat format. For example pls find the below code, #! /bin/sh result=' sqlplus -s uname/passwrd@DBname select no,name,address,ph_no, passport_no,salary,designation from emp_table where salary>1000; exit EOF' ... (8 Replies)
Discussion started by: little_wonder
8 Replies

4. Shell Programming and Scripting

Oracle SQL Query & connect?

Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies

5. UNIX for Advanced & Expert Users

Output the SQL Query result to a File

Hello Guys, This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help. Here is my script- #! /bin/ksh export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2 /opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies

6. Shell Programming and Scripting

Read value from user and use it in Oracle SQL query

Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query? e.g. echo "enter value" read value insert into tablename where col=$value /*something like this*/ (1 Reply)
Discussion started by: subodh.thakar
1 Replies

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks (1 Reply)
Discussion started by: tdev457
1 Replies

8. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

9. UNIX for Dummies Questions & Answers

Removing unnecessary eol ($) character from Oracle sql query output

Hi All, I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each line ends with $ character. I want to remove these unnecessary $ character but to keep required $... (8 Replies)
Discussion started by: Harshal22
8 Replies

10. Shell Programming and Scripting

Get SQL query result to file in putty

How to Get SQL query result to file in putty? I have one SQL query and I want that query output to be redirected to the file. uname -a SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R Please suggest. (7 Replies)
Discussion started by: pamu
7 Replies
PART(8) 						      System Manager's Manual							   PART(8)

NAME
part - partition table editor SYNOPSIS
part [device] ... DESCRIPTION
Part is a screen oriented partition table editor. While editing you will see six lines of numbers, the first line shows the device name and its geometry (number of cylinders, heads and sec- tors), the second shows the start and end of the drive or partition you are working on, the last four lines show the different partitions or subpartitions. All numbers except those on the second line can be edited. Question marks are showed instead of numbers if the parti- tion table is not loaded yet. You have to select a device and type 'r'. Editing is a simple matter of moving around with the arrow keys and changing the values with + and - (or PgUp and PgDn), or by typing the desired value. The '?' key will give a small list of commands, the '!' key gives advice on how to make a new entry. The spacebar toggles between showing the size of the partition and the last sector on the partition. Useful to check if a partition is adjacent to the next. The 'm' key is "magical", it lets you cycle through a set of interesting values for the base or size of a partition. These values are: Aligned to a cylinder, taped to other partitions (inside or outside), or filling out holes. Use this key! Minix subpartition tables or extended partitions may be edited after hitting the '>' key. The number of this partition will be shown after the device name on the second row, e.g. /dev/hd0:2. Minix subpartition tables are shown as is, but extended partition bases are trans- lated to absolute offsets on the screen to hide the gory details of their implementation from the innocent user. (Hit 'p' if you dare.) The '<' key will bring you back to the enclosing partition table. With arguments, part will use the given devices or files. Without arguments, part will use all interesting block devices in /dev sorted by device number and starting with /dev/hd0. Values that are out of range, overlapping, or otherwise strange are shown in reverse video. Values that may possibly be a problem for operating systems other then Minix are shown in bold characters. The name of the device is highlighted when it has not been read yet. Head or sector numbers are highlighted if the partition does not start or end at a cylinder boundary. The base and/or size field is highlighted if they fall outside the device, if they are inside some other partition, if the base equals the device's base (no room for the boot sector), or if the size is zero. Part complies with the good old UNIX tradition of trusting the user. It will write any table, no matter how bad. You have been warned. By the way, as far as Minix is concerned there is absolutely no reason to make partitions start precisely on a cylinder or track nor does it have to be an exact number of cylinders long. Minix only looks at the base and size of a partition, the geometry of the drive doesn't have to be correct. Other Operating systems can be very picky about partitions that are not aligned. Some partition editors may refuse to edit a table, others may even make a mess of the table. The only exception is the first partition, it traditionally starts on the first track, not the first cylinder. All editors must understand this. (Subpartition tables are Minix specific, so there is no reason at all for any alignment.) Extended Partitions Extended partitions are a mess that is only made slightly better by part by translating the base offsets to absolute numbers. It is better to use DOS fdisk to create them, but if you insist on using part then this is what they should look like: The extended partition entry in the primary partition table must cover the whole logical partition space within it. The area thus created is split in segments, each segment contains a partition table in sector 0 and one (just one) logical parti- tion. The first entry of a segment's partition table describes this logical partition: it's partition ID, base and size. The second entry is an extended partition that describes base and size of the next segment (partition table and logical partition). The last segment's partition table is empty, or contains one logical partition. SEE ALSO
fd(4), hd(4). BUGS
You can have a table read, messed up, and written in no time, be careful. You can't type head or sector numbers directly. Sectors are counted from 0 for consistency, but the partition table counts from 1 like DOS addresses them. Most confusing. You can't write a backup copy to a file, that's what dd(1) with count=1 is for. AUTHOR
Kees J. Bot (kjb@cs.vu.nl) PART(8)
All times are GMT -4. The time now is 01:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy