Sponsored Content
Operating Systems Solaris not getting the output properly Post 302186047 by pmrajesh21 on Wednesday 16th of April 2008 10:43:46 AM
Old 04-16-2008
not getting the output properly

i am entering the command, not get the total out put

see the output what i am getting.

Code:
SQL>  select dbms_metadata.get_ddl ('TABLESPACE','SYSTEM') FROM DUAL;

DBMS_METADATA.GET_DDL('TABLESPACE','SYSTEM')
--------------------------------------------------------------------------------

  CREATE TABLESPACE "SYSTEM" DATAFILE
  '/u0101/oradata/GFSSS1/system01.dbf' S


SQL>


can u please suggest me , which perameters i have to set.

Last edited by Yogesh Sawant; 04-16-2008 at 12:04 PM.. Reason: added code tags
 

10 More Discussions You Might Find Interesting

1. Programming

y is this not working properly?

#include <stdio.h> #include <sys/types.h> #include <string.h> #include <sys/stat.h> #include <unistd.h> struct stat s; main() { char c; if (fork()==0) { system("clear"); do { printf("myAI\\>§ "); scanf("%s",c); if(stat(c,&s)>-1) {... (3 Replies)
Discussion started by: C|[anti-trust]
3 Replies

2. UNIX for Dummies Questions & Answers

How to output the results of the AT command - properly!

Hi, I am new to UNIX and I am more used to simple commands like those in VMS. One of them is the ability to get the output from a job using the /out=<file> command in VMS. I want to submit a job (a set of unix commands) using the AT command but to get the output in a file like that used in... (4 Replies)
Discussion started by: SpanishPassion
4 Replies

3. Shell Programming and Scripting

Output in my shell isn't showing properly.

Hi! Can anyone tell me what went wrong in my shell script? for dt_val in `cut -f 1 -d '|' /prod/ods/satyaki/sqlldr/grp.dat` do echo $dt_val done And, the output is - 23 39 (7 Replies)
Discussion started by: satyakide
7 Replies

4. Shell Programming and Scripting

Korn: How to zero fill df output so it will sort properly

I'm looking for a way in Korn shell to zero fill (or space fill) the output from df so that it will sort properly. "Raw" output from df -k: df -k Filesystem kbytes used avail capacity Mounted on /dev/vx/dsk/rootvol 4131866 3593302 497246 88% / /proc ... (9 Replies)
Discussion started by: shew01
9 Replies

5. Shell Programming and Scripting

\n not working properly

Hi all, I'm trying to generate a series of txt files starting from a plain csv file part of my code: #!/bin/ksh INSTALLDIR=/Users/ME/Installdir CSV=CSV.csv TMP=/tmp/$(basename $0).txt tr -s "\r" "\n" < /$INSTALLDIR/$CSV > $TMP function Makefiles { printf '%24s:%30s\n' "sometext"... (1 Reply)
Discussion started by: Jive Spector
1 Replies

6. Shell Programming and Scripting

cp not coping properly

Hi, I'm trying to copy the directories from one location(/tmp/source/) to other(/tmp/dest/). for this I have written a PERL script. snippet of code $sourcePath = "/tmp/source"; $destPath = "/tmp/dest"; opendir(DIR, $sourcePath ); while($dir = readdir(DIR)) { if($dir ne "." && $dir ne... (1 Reply)
Discussion started by: prashants
1 Replies

7. IP Networking

Not able to FTP properly

FTP error: ftp> dir */*/*/*.zip 227 Entering Passive Mode (10,58,132,123,204,83) 150 Here comes the directory listing 226 Transfer done (but failed to open directory) And the machine where am getting the file(Client machine) has the below mentioned vsftpd.conf file. Please let me know... (2 Replies)
Discussion started by: weknowd
2 Replies

8. Shell Programming and Scripting

How to paste properly?

I needed to view calendar for several months so I created a separate file for each and then pasted them like this: cal Dec 2011 > x1; cal Jan 2012 > x2; paste x1 x2 December 2011 January 2012 Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa 1 2 3 1 2 ... (4 Replies)
Discussion started by: migurus
4 Replies

9. Shell Programming and Scripting

How to use Grep properly?

Hi Forum Im making a script that takes multiple unix users and lists the users and the groups that the user is part of. the grouplist looks like this grouplst="example_group1|example_group2|example_group3|example_group4" I got most of it working but Im having trouble with a while loop... (4 Replies)
Discussion started by: ajetangay
4 Replies

10. UNIX for Beginners Questions & Answers

Can't get mv to work properly

Trying to use mv in a shell script but for some reason this does not work: for f in *.wav;do mv $f $f.bwf;done I get this: usage: mv source target mv source ... directory So it's like I'm using 'mv' wrong but I can't see how. This works so the contens of the folder is read... (4 Replies)
Discussion started by: Oortone
4 Replies
DROP 
TABLESPACE(7) SQL Commands DROP TABLESPACE(7) NAME
DROP TABLESPACE - remove a tablespace SYNOPSIS
DROP TABLESPACE [ IF EXISTS ] tablespacename DESCRIPTION
DROP TABLESPACE removes a tablespace from the system. A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are using the tablespace. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to temporary files residing in the tablespace. PARAMETERS
IF EXISTS Do not throw an error if the tablespace does not exist. A notice is issued in this case. tablespacename The name of a tablespace. NOTES
DROP TABLESPACE cannot be executed inside a transaction block. EXAMPLES
To remove tablespace mystuff from the system: DROP TABLESPACE mystuff; COMPATIBILITY
DROP TABLESPACE is a PostgreSQL extension. SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], ALTER TABLESPACE [alter_tablespace(7)] SQL - Language Statements 2010-05-14 DROP TABLESPACE(7)
All times are GMT -4. The time now is 05:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy