03-25-2017
Have you considered rather using symlinks to achieve desired result ?
You can also manipulate your database location from inside database itself using TABLESPACE.
It's much easier to maintain a database defined location, then symlink/bind stuff around.
That way you can manipulate underlying storage via LVM and have unified configuration for all your hosts regardless of size.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi people,
I'm trying to create a mount point, but am having no sucess at all, with the following:
mount -F ufs /dev/dsk/diskname /newdirectory
but i keep getting - mount-point /newdirectory doesn't exist.
What am i doing wrong/missing?
Thanks
Rc (1 Reply)
Discussion started by: colesy
1 Replies
2. UNIX for Dummies Questions & Answers
hi
can i know what is the command to create auto mount point in my unix server? is there any directory which i have to go? (1 Reply)
Discussion started by: legato
1 Replies
3. UNIX for Advanced & Expert Users
is there any command to know the list of mount points in a server.i need only the mount point lists.i tried using df but it was not helpful.i am using Solaris (1 Reply)
Discussion started by: dr46014
1 Replies
4. AIX
Hello, I have an AIX Oracle database server that I need to create a new filesystem/mount where I can create a new ORacle home to install 11g on. What are the needed steps to create this? There are mounts for Oracle 9i and 10g already. Thank you.
- David (7 Replies)
Discussion started by: dkranes
7 Replies
5. Solaris
Dear Gurus,
Could it be possible to have the output of df -k sorted? The df -k output messed up after recent power trip.
Also, is there any folders that I should look into to reduce the root size (other than /var/adm and /var/crash) after server crash?
Many thanks in advance.
... (2 Replies)
Discussion started by: honmin
2 Replies
6. UNIX for Dummies Questions & Answers
I read it create hard link but I want to be sure,
what does this command do exactly?
Thank in advance. (1 Reply)
Discussion started by: programAngel
1 Replies
7. Red Hat
Hi All,
we have an issue in bind mounting LINUX.
we are able to see the bound mounts in mount command and
df -h <file system name> but they are not visible in normal df -h command.
all these mounts are local mounts.
we have a /xyz is mount and abc is a directory in /xyz ( /xyz/abc )
... (1 Reply)
Discussion started by: Naveen.6025
1 Replies
8. Emergency UNIX and Linux Support
I have a sftp server running on Centos 5.10. It servers as upload/download interface for three users who basically are chrooted to three different locations.
User A -- > /home/REGIONA/
User B -- > /home/REGIONB/
User C -- > /home/REGIONC/
The users run certain application procedures on... (4 Replies)
Discussion started by: maverick_here
4 Replies
9. UNIX for Beginners Questions & Answers
guys i would like to know can we have 2 mount point which is same name but on different directory? (3 Replies)
Discussion started by: leecopper
3 Replies
10. UNIX for Beginners Questions & Answers
How to create a new mount point with 600GB and add 350 GBexisting mount point
Best if there step that i can follow or execute before i mount or add diskspace IN AIX
Thanks (2 Replies)
Discussion started by: Thilagarajan
2 Replies
LEARN ABOUT SUSE
drop_tablespace
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)