impdp system/pwd schemas=ENILAI remap_schema=ENILAI:enilaidc
remap_tablespace=ENILAI:enilaidc directory=dmpdir dumpfile=ENILAI11G.DMP
logfile=enilaidc_20211118.log
SYSTEM account.SYSTEM account is one of a handful of predefined administrative accounts generated automatically when Oracle is installed. SYSTEM is capable of most administrative tasks, but the task we’re particularly interested in is account management.SYSTEM, simply issue the CREATE USER command to generate a new account.CREATE USER books_admin IDENTIFIED BY MyPassword;
books_admin account that is IDENTIFIED or authenticated by the specified password.books_admin account created, we can now begin adding privileges to the account using the GRANT statement. GRANT is a very powerful statement with many possible options, but the core functionality is to manage the privileges of both users and roles throughout the database.CONNECT role:GRANT CONNECT TO books_admin;
RESOURCE role (allowing the user to create named types for custom schemas) or even the DBA role, which allows the user to not only create custom named types but alter and destroy them as well.GRANT CONNECT, RESOURCE, DBA TO books_admin;
GRANT CREATE SESSION. We’ll also combine that with all privileges using GRANT ANY PRIVILEGES.GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;
GRANT TABLESPACE like so:GRANT UNLIMITED TABLESPACE TO books_admin;
books_admin user to have the ability to perform SELECT, UPDATE, INSERT, and DELETE capabilities on the books table, we might execute the following GRANT statement:GRANT
SELECT,
INSERT,
UPDATE,
DELETE
ON
schema.books
TO
books_admin;
books_admin can perform the four basic statements for the books table that is part of the schema schema.SQL> connect SYSTEM/fyicenter Connected. SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS 2 FROM USER_TABLESPACES; TABLESPACE_NAME STATUS CONTENTS ------------------------------ --------- --------- SYSTEM ONLINE PERMANENT UNDO ONLINE UNDO SYSAUX ONLINE PERMANENT TEMP ONLINE TEMPORARY USERS ONLINE PERMANENT
SQL> select owner, table_name, tablespace_name 2 from dba_tables 3 where owner in ('SCOTT', 'HR') 4 order by owner, tablespace_name, table_name; OWNER TABLE_NAME TABLESPACE_NAME ------------------------------ ------------------------------ ---------------- HR DEPARTMENTS USERS HR EMPLOYEES USERS HR JOBS USERS HR JOB_HISTORY USERS HR LOCATIONS USERS HR REGIONS USERS HR COUNTRIES 7 rows selected.
SELECT owner, table_name
FROM dba_tablesDBA_TABLES data dictionary view. If you do not have those privileges but need them, you can request that the DBA explicitly grants you privileges on that table, or, that the DBA grants you the SELECT ANY DICTIONARY privilege or the SELECT_CATALOG_ROLErole (either of which would allow you to query any data dictionary table). Of course, you may want to exclude certain schemas like SYS and SYSTEM which have large numbers of Oracle tables that you probably don't care about.DBA_TABLES, you can see all the tables that your account has access to through the ALL_TABLES view:SELECT owner, table_name
FROM all_tablesALL_TABLES shows you the information for all the tables that your user has been granted access to).USER_TABLES:SELECT table_name
FROM user_tablesUSER_TABLES only has information about the tables that you own, it does not have an OWNERcolumn – the owner, by definition, is you.TAB, DICT, TABS, and CAT for example-- that could be used. In general, I would not suggest using these legacy views unless you absolutely need to backport your scripts to Oracle 6. Oracle has not changed these views in a long time so they often have problems with newer types of objects. For example, the TAB and CATviews both show information about tables that are in the user's recycle bin while the [DBA|ALL|USER]_TABLES views all filter those out. CAT also shows information about materialized view logs with a TABLE_TYPE of "TABLE" which is unlikely to be what you really want. DICTcombines tables and synonyms and doesn't tell you who owns the object.sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=protocol)(HOST=host)(PORT=port))(CONNECT_DATA=(SID=sid)))
sqlplus username/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.110.70.199)(PORT=1521))(CONNECT_DATA=(SID=xe)))
Credit to https://hecpv.wordpress.com/2015/04/29/how-to-connect-to-a-remote-oracle-database/
