|
-
[QUOTE][i]Originally posted by heather [/i]
[B]I had oracle installer create a database for me. How do I know what the name of the tablespace that it created is? Thanks for any help you can give me! [/B][/QUOTE]
Connect like system , sys or internal on Sqlplus
-- Tablepace name only
select tablespace_name from dba_tablespaces;
or
-- Tablepace name and the file name
select tablespace_name , file_name from dba_data_files;
H
Hudson
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|