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

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(') ...


1

Are the 37 indexes you have on the table global indexes? Option 1: Where you truncate and then rebuild This method is most appropriate if the partition that you are truncating has at least 10% of the total data in the table. But rebuilding these 37 indexes is going to take time. Option 2: Where you delete and truncate the partition The delete statement ...



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