Hot answers tagged

4

there's a space missing before to in 'to myuser'. BEGIN FOR X in (select * from all_tables where owner in ('TESTDTA', 'TESTCTL')) LOOP EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||X.owner||'.'||X.table_name|| ' to TESTUSER'; END LOOP; END; /


2

Listener is a process running in the Oracle Server machine. The responsibility of the listener is to listen for the incoming database connection request and spawning server process to handle the request(in Dedicated Server mode) or handing over to dispatcher process(in Shared-Server mode). In RAC architecture we have SCAN listener to redirect connection ...


1

First of all, people often fall for this, but high log file sync waits do not necessarily mean I/O problem. Second, this could be really troublesome, if you have many physical devices in the ASM diskgroup where your redo logs are, because the extents of your files will be evenly distributed on several disks. Anyway, you need to find the ASM diskgroup ...


1

It only allows access to data dictionary views, so the only security implication is that the users(s) would be able to see which objects existed in the other schemas. They would not, however, be able to actually view the data in the other schemas. I said there was only one security implication, but another is that they would be able to view the source of ...


1

If you are trying generate SQL to create empty tables for all tables then the SQL you have written might be okay. There is couple of errors which I have corrected as: select 'CREATE TABLE INTDTA.' ||table_name|| ' AS SELECT * FROM ZRTDTA.' || table_name || ' where 1=2;' from all_tables where owner='ZRTDTA'; If you want to use single quotation mark(') ...



Only top voted, non community-wiki answers of a minimum length are eligible