Aug
07
1.EXPORT:
exp system@test owner=test123 file=d:\oracle\user.dmp log=d:\oracle\userdump.log
rows=y statistics=none feedback=100 indexes=y consistent=y compress=n;
(for individual tables=table1,table2,.....)
2.IMPORT:
imp system@test fromu…
more »
Tags: access, account, add, already, alter, calculate, check, command, connected, control, count, create, creating, database, datafile, datafiles, debug, dropped, end, error, error:ora-00001, export, file, files, get, give, grants, import, include, indexes, information, install, installed, kill, linux, manually, monitoring, object, oc4j_bi_forms, ods.ods_process, os, particular, path, procedure, regarding, report, resize, restart, schema, script, select, server, session, sessions, solaris, space, spfile, spid, status, steps, system, table, tablespace, temp, tempfile, temporary, trace, unix, used, user, username, users, windows
Aug
06
create user [username] identified by [password] default tablespace
[tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name];
more »
Tags: create, give, grants, oracle, user
XML Feeds
Recent comments