Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

bytes to megabytes

Status
Not open for further replies.
Thiko

Thiko

Programmer
Mar 9, 2001
49
GB
i would like to find out the size that some database datafiles were created at in megabytes.

so if i select bytes from dba_data_files could someone tell me the syntax for convering the size information into megabytes? Many Thanks.

Thiko!
 
Sort by date Sort by votes
select bytes/1024/1024 "Mbytes", tablespace_name from dba_data_files; Many Thanks.

Thiko!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
645
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
618
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
678
carp
carp
TheLazyPig
  • Locked
  • Question
Separate 1 row value to multiple rows
Replies
4
Views
645
carp
carp
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top