Menu de navegação

[Edilson FeitozaParticipante]

Sou novato no Oracle e comprei esse livro para auxiliar no meu aprendizado, só que estou com problemas na execução de alguns scripts do livro, como por exemplo oscript abaixo:

column free_space_gb format 9999999.999
column allocated_gb format 9999999.999
column used_gb format 9999999.999
column tablespace format a12
column filename format a20
select ts.name tablespace, trim(substr(df.name,1,100)) filename,
df.bytes/1048576000 allocated_gb,((df.bytes/1048576000) – nvl(sum(dfs.bytes)/1048576000,0))
used_gb,nvl(sum(dfs.bytes)/1048576000,0) free_space_gb
from v$datafile df
join dba_free_space dfs on df.file# = dfs.file_id
join v$tablespace ts on df.ts# = ts.ts#
group by ts.name, dfs.file_id, df.name, df.file#, df.bytes
order by filename;

Gera um erro assim:

ORA-00911: caractere inválido
00911. 00000 – “invalid character”
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q’#…#’) cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:
Erro na linha: 12 Coluna: 57

Detalhe estou usando o Oracle SQL DEVELOPER em um Oracle 11G

Agora não sei se estou colocando o script de maneira correta ou o script tem algum erro!!

[rmanParticipante]

@Edilson Feitoza

No SQL Developer execute:


select ts.name tablespace, trim(substr(df.name,1,100)) filename,
df.bytes/1048576000 allocated_gb,((df.bytes/1048576000) – nvl(sum(dfs.bytes)/1048576000,0))
used_gb,nvl(sum(dfs.bytes)/1048576000,0) free_space_gb
from v$datafile df
join dba_free_space dfs on df.file# = dfs.file_id
join v$tablespace ts on df.ts# = ts.ts#
group by ts.name, dfs.file_id, df.name, df.file#, df.bytes
order by filename;


Esse comandos são do sqlplus para formatação:

column free_space_gb format 9999999.999
column allocated_gb format 9999999.999
column used_gb format 9999999.999
column tablespace format a12
column filename format a20


[Autor]

Posts