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
PDISK(8)						    BSD System Manager's Manual 						  PDISK(8)

NAME
pdisk -- Apple partition table editor SYNOPSIS
pdisk [-acdfhilLrv] [--abbr] [--compute_size] [--debug] [--fname] [--help] [--interactive] [--list] [--logical] [--readonly] [--version] [device ...] DESCRIPTION
pdisk is a menu driven program which partitions disks using the standard Apple disk partitioning scheme described in "Inside Macintosh: Devices". It does not support the Intel/DOS partitioning scheme supported by fdisk(8). Supported options are: -a --abbr Abbreviate the partition types shown in the partition list. -c --compute_size Causes pdisk to always ignore the device size listed in the partition table and compute the device size by other means. -d --debug Turns on debugging. Doesn't add that much output, but does add a new command 'x' to the editing commands that accesses an eclectic bunch of undocumented functionality. -f --fname Show HFS volume names instead of partition name when available. -h --help Prints a short help message. -i --interactive Causes pdisk to go into an interactive mode similar to the MacOS version of the program. -l --list If no device argument is given, pdisk tries to list partition tables for all available drives. Otherwise, pdisk lists the partition tables for the specified devices. -L --logical Show partition limits in logical blocks. Default is physical blocks. -r --readonly Prevents pdisk from writing to the device. -v --version Prints the version number of pdisk. Editing Partition Tables An argument which is simply the name of a device indicates that pdisk should edit the partition table of that device. The current top level editing commands are: C (create with type also specified) c create new partition d delete a partition h command help i initialize partition map n (re)name a partition P (print ordered by base address) p print the partition table q quit editing (don't save changes) r reorder partition entry in map s change size of partition map t change the type of an existing partition w write the partition table Commands which take arguments prompt for each argument in turn. You can also type any number of the arguments separated by spaces and those prompts will be skipped. The only exception to typeahead are the confirmation prompts on the i and w commands, since if we expect you to confirm the decision, we shouldn't undermine that by allowing you to be precipitate about it. Partitions are always specified by their number, which is the index of the partition entry in the partition map. Most of the commands will change the index numbers of all partitions after the affected partition. You are advised to print the table as frequently as necessary. The c (create new partition) command is the only one with complicated arguments. The first argument is the base address (in blocks) of the partition. Besides a raw number, you can also specify a partition number followed by the letter 'p' to indicate that the first block of the new partition should be the same as the first block of that existing free space partition. The second argument is the length of the parti- tion in blocks. This can be a raw number or can be a partition number followed by the letter 'p' to use the size of that partition or can be a number followed by 'k', 'm', or 'g' to indicate the size in kilobytes, megabytes, or gigabytes respectively. (These are powers of 1024, of course, not powers of 1000.) The third argument is the name of the partition. This can be a single word without quotes, or a string sur- rounded by single or double quotes. The C command is similar to the c command, with the addition of a partition type argument after the other arguments. The i (initalize) command prompts for the size of the device. The n (name) command allows the name of a partition to be changed. The r (reorder) command allows the index number of partitions to be changed. The index numbers are constrained to be a contiguous sequence. The t (change partition type) command allows the type of a partition to be changed. The w (write) command writes the partition map out. SEE ALSO
fdisk(8), gpt(8), newfs(8) HISTORY
The pdisk utility was originally developed for MkLinux. AUTHORS
Eryk Vershen BUGS
Some people believe there should really be just one disk partitioning utility. Filesystem volume names are out of place in a partition utility. This utility supports HFS volume names, but not volume names of any other filesystem types. The --logical option has not been heavily tested. BSD
April 24, 2003 BSD
All times are GMT -4. The time now is 01:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy