In article <36486700.65354411_at_news.vt.edu>, wwwebmaster_at_vt.edu writes
>I'm sure this is a silly question, but I've inherited a database i
>know little about and need to know how to list who owns what
>tablespace for small things like exporting a table.
>Maybe I'm doing this wrong too?
>Exp oracle/passwd file= /export/filename.dmp tables=owner.tablename
>
You seem a little confused! Tablespaces are not owned by anyone. Tables
are owned by users. To see a list of tables, their owner and the
tablespace in which they are currently living (the tables, not the
owners!) try :-
SELECT TABLE_NAME, OWNER, TABLESPACE_NAME FROM ALL_TABLES
HTH
--
Tim Shute
Software Engineering Manager
NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH
Internet: www.nisoft.co.uk
Received on Wed Nov 11 1998 - 06:39:42 CST
